Return Date Picker Value in 24hour / military format

This may be the dumbest question but have been exploring options and not working:

  • While I am managing to display the time in 24h format in the date picker, in the database it is saved in 12 hour am/pm format. I need to send an email to users with that saved time value, but want it to be in 24h format again - not managing to get it and it is probably super easy to solve.

Thank you!

Screenshot 2022-11-22 at 11.40.21

It’s not…

A date/time is just a timestamp… it has no format…

So a date/time is not saved in the database in 12 hour am/pm format (although it might be displayed in that format on the data tab of your app editor)… it’s just a timestamp of a specific moment (millisecond)…

You can take the timestamp (date/time) and format it anyway you like to display it as a text, either on the page, or anywhere else where a text value can be entered (such as in an email)…

So, if you want to format the date/time in a specific way in an email just use ‘Formatted As’ after specifying the date/time, then you can format the date/time anyway you like.

Thanks! Indeed it was all about just going all the way to the custom format and then playing with the time stamp components - pretty easy once there but the custom option is in the very bottom when it should come first!