Teri Bridges
Member
- Local time
- Today, 05:47
- Joined
- Feb 21, 2022
- Messages
- 186
I want to create a due date and if the due date falls on a weekend move it to monday
I can write DueDate=[startdate]+3 this gives me my due date
I can write =IIF(Weekday([duedate])=1,[duedate]+1,IIF(Weekday([duedate])=7,[duedate]+1)) and that works now I have a second duedate field
I want to combine the statements into one duedatefield. I cannot seem to figure out how to write it
I can write DueDate=[startdate]+3 this gives me my due date
I can write =IIF(Weekday([duedate])=1,[duedate]+1,IIF(Weekday([duedate])=7,[duedate]+1)) and that works now I have a second duedate field
I want to combine the statements into one duedatefield. I cannot seem to figure out how to write it