Forum Discussion

ITSupport's avatar
ITSupport
Qrew Trainee
8 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
ITSupport's avatar
ITSupport
Qrew Trainee
8 years ago
Tried that but problem with "Right" is then I get AM and PM and can't have that. 
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
I tested this and it works:

Right("0" & NotRight(ToText([Appointment Time]), 3), 5)

Using short field names because I am lazy: