Forum Discussion

ITSupport's avatar
ITSupport
Qrew Trainee
6 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
I tested this and it works:

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

Using short field names because I am lazy:

YobaniMaldonado's avatar
YobaniMaldonado
Qrew Member
2 years ago
Nice work! 

Is there a way to include seconds as well. I had the same issue trying to get rid of the PM and AM and this worked, but I need seconds to be recorded as well. Is that possible? 

Thank you.

------------------------------
Yobani Maldonado
------------------------------