Forum Discussion

ITSupport's avatar
ITSupport
Qrew Trainee
7 years ago

Date Time Format of MM/DD/YYYY HH:MM for integration to GoCanvas

Been going round and round to maintain this format.  I cannot pass the AM or PM of the time and would like it to be in 24 hour format but that doesn't hold either.  So created formula to take date fie...
Formulas and functions
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
I think you should be using Right() instead of Left():
ToText([Date Scheduled]) &
" " & 
Right("0" & ToText([Appointment Time]), 5)