Forum Discussion
- QuickBaseCoachDQrew CaptainTry this
var Date DatePart = Left([shipment-date],"T");
var TimeOfDay TimePart = Right([shipment-date],"T");
ToTimeStamp($DatePart, $TimePart ) - SamKrauszQrew CadetThanks for your help
But....
I am getting an error "incorrect variable type"
Any idea what this is? - QuickBaseCoachDQrew Captainre: Any idea what this is?
yes: Sloppiness on my part :)
OK, let's try that again
Try this
var Date DatePart = ToDate(Left([shipment-date],"T"));
var TimeOfDay TimePart = ToTimeOfDay(Right([shipment-date],"T"));
ToTimeStamp($DatePart, $TimePart ) - SamKrauszQrew CadetI am not getting any error massages
But when I save it, the cell is blank, no data in the cell - QuickBaseCoachDQrew CaptainOK, this is tested
var date DatePart = Date(
ToNumber(Left([shipment-date],4)),
ToNumber(Mid([shipment-date],6,2)),
ToNumber(Mid([shipment-date],9,2)));
var TimeOfDay TimePart = ToTimeOfDay(Mid([shipment-date],12,5));
ToTimestamp($DatePart, $TimePart ) - SamKrauszQrew CadetThanks for the great help
It's really appreciate, it was a big help
Thanks