Calculating SLA Start Date
I am tracking SLA in my app, my problem is my start date needs to be figured by a time stamp and exclude weekends and holidays. For example: If the time stamp is before 12:00 PM it is the same day, ...
Forum Discussion
Try the formula below. Looks like there is just one parenthesis too many. Let me know if the below formula works better
If(ToTimeOfDay([Order Date])<ToTimeOfDay("12 PM"),ToDate([Order Date]),WeekdayAdd(ToDate([Order Date]),3))
If(ToTimeOfDay([Order Date])<ToTimeOfDay("12 PM"),ToDate([Order Date]),WeekdayAdd(ToDate([Order Date]),3))