Advance date field by 1 day

[MCDR929]

Hi group - 

This should be a layup for a lot of you.

I just need to add 1 day to a date field when another field has a given value.

as in:

If [field]="20" then [datefield] +1 day

Actually, my IDEAL solution would be to advance my "day of week" field to the next day of the week (Monday-Friday preferred).  I know that might be a more complicated solution, and I'm limited on time, so whatever anyone can suggest would be a huge help.

Thanks!

[benakesh · Accepted solution]

Hi @MCDR929 ,

Try this for next work day  .  Formula adds  3 for  Friday or adds 1 day .

iif(
DateTimeFormat([Field1],'%a') = 'Fri' ,
DateTimeAdd([Field1],3,'days') ,
DateTimeAdd([Field1],1,'days')
)

[MCDR929]

Perfect, thank you!