Forum Discussion
MarkShnier__You
Qrew Legend
3 years agotry this
var text RequestDueDate = WeekDayAdd(ToDate([Request Received Date]), [TAT]);
var text RequestDueTime = ToTimeOfDay([Request Received Date]);
ToTimeStamp($RequestDueDate, $RequestDueTime)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
manoharvankired
3 years agoQrew Trainee
The data type of the variable changes from datetime in the first line to Var text and then back to datetime in the second line, but in between, it is represented as timeofday.
------------------------------
manohar vankireddy
------------------------------
- MarkShnier__You3 years ago
Qrew Legend
Corrected
var Date RequestDueDate = WeekDayAdd(ToDate([Request Received Date]), [TAT]);
var TimeOfDay= RequestDueTime = ToTimeOfDay([Request Received Date]);
ToTimeStamp($RequestDueDate, $RequestDueTime)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- manoharvankired3 years agoQrew Trainee
Thank You Mark
------------------------------
manohar vankireddy
------------------------------