Forum Discussion

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

Qrew Trainee

7 years ago

Tried that but problem with "Right" is then I get AM and PM and can't have that.

_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
  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
  ------------------------------
_anomDiebolt_
Qrew Elite
7 years ago
To trim off the " AM" or " PM" from the right try this:
ToText([Date Scheduled]) &
" " &
NotRight(Right("0" & ToText([Appointment Time]), 5), 3)
ITSupport
Qrew Trainee
7 years ago
Thank you - this is super close. Made a minor tweak to get it to display right - used 8 instead of 5. But still having issue with the leading zero

With below formula:

08:00 displays correctly 08:00
10:00 displays this 010:00

Some how need to add zero when time is <10:00 but not display for 10:00-12:00 if that makes sense

ToText([Date Scheduled]) &" " &
NotRight("0" & Right(ToText([Appointment Time]), 8), 3)
ITSupport
Qrew Trainee
7 years ago
ah ok - you flipped the 3, 5 Thanks again!