Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 14, 2020 02:41 PM
I have a field called “Event Date” and I want to calculate 3 WORKDAYS before that event date. So if the event is on a Thursday, it will give me the date of the previous Monday but if the Event is on a Monday, it gives me the previous Wednesday as it ignores the weekend… I want to ignore the time.
Any help would be appreciated.
Feb 14, 2020 02:51 PM
Does this work for you?
DATETIME_FORMAT(WORKDAY({Event Date}, -3),'l')
Feb 14, 2020 03:38 PM
Like a charm.Thanks!