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)
Thank you, Mark. This was what I needed. Quickbase accepted this function with an extra set of parenthesis and it appears to work, though I'll create a record on the weekend just to make sure. And I also learned from your example that I can comment within a line, which I had never done before. :-)
ToTimeStamp(
ToWeekDayN(ToDate([Date Created])) ,
ToTimeOfDay([Date Created])
+ Hours(48))