Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Jun 11, 2022 07:51 AM
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?
Jun 11, 2022 09:41 AM
Hi and welcome @Joan_Born!
This should work for you
IF(
{Date field},
DATEADD(DATEADD({Date field},-2,'weeks'),4-WEEKDAY({Date field}),'days')
)