Duration of 48 hours starting on a workday

Question

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]+Hours(48), which shows the date/time 48 hours later, but if the record is created Saturday morning at 10am, for example, I would need the countdown to start as of Monday morning 8am. I thought about using ToWorkDate, then WorkDateAdd, but I believe I would lose the time component, so am not sure that will work for the date/time field type.

Any suggestions?

MarkShnierYou · Answer

not tested but try thisToTimeStamp(     // this function returns a date / time result when given a date and a Time of dayToWeekDayN(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)

Sign up

Login to the community