Duration of 48 hours starting on a workday
Greetings. I am trying to create a Due Date/Time field that would show 48 hours from the Date Created for a record, but need to take into account work hours. Right now my formula is [Date Created]+H...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnot tested but try this
ToTimeStamp( // this function returns a date / time result when given a date and a Time of day
ToWeekDayN(ToDate([Date Created]), // this function will bump the date ahead if it falls on a weekend.
ToTimeOfDay([DateCreated]) // just the time of date portion of a date/time field
+ Hours(48)