Forum Discussion
MarkShnier__You
5 months agoQrew Legend
not 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)
- DougCrandall5 months agoQrew Cadet
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))