Forum Discussion
MarkShnier__You
2 years agoQrew Legend
try 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
------------------------------
- manoharvankired2 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__You2 years agoQrew 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
------------------------------- manoharvankired2 years agoQrew Trainee
Thank You Mark
------------------------------
manohar vankireddy
------------------------------