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
ITSupport's avatar
ITSupport
Qrew Trainee
7 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
7 years ago
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
    3 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
    ------------------------------