TechsystemMan
New member
- Local time
- Today, 12:25
- Joined
- Jan 30, 2018
- Messages
- 4
Hi can you help?
I have 3 field in a table
Opened date / Status / Target date
There are 4 status Critical , Major, Minor & low
I want the Target date field to autofill
If status is critical the target date is opened date plus 1 day
If status is major the target date is opened date plus 2 days
If status is minor the target date is opened date plus 14 days
If status is low the target date is opened date plus 28 day
If tried using setting the Target Field as a calculation and using an IIF function but gets errors.
Can you suggest how to do this please.
I am a novice user, learning from youtube and google.
I have 3 field in a table
Opened date / Status / Target date
There are 4 status Critical , Major, Minor & low
I want the Target date field to autofill
If status is critical the target date is opened date plus 1 day
If status is major the target date is opened date plus 2 days
If status is minor the target date is opened date plus 14 days
If status is low the target date is opened date plus 28 day
If tried using setting the Target Field as a calculation and using an IIF function but gets errors.
Can you suggest how to do this please.
I am a novice user, learning from youtube and google.