Hi - I’m trying to set a due date that is two weeks out from a publish date on the nearest Thursday. Essentially, everything that is set to be published in week 25, should be due the Thursday of week 23. Does anyone have any hot tips on how to formulate this one?
Assign a due date of Thursday for all items due in a certain week
+14Hi and welcome @Joan_Born!
This should work for you
IF(
{Date field},
DATEADD(DATEADD({Date field},-2,'weeks'),4-WEEKDAY({Date field}),'days')
)
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.