Someone might have a simpler & easier formula for this, but I just quickly whipped this together and it seems to work. You’ll want to choose your own timezone from the list of supported time zones.
DATETIME_PARSE(
DATETIME_FORMAT(SET_TIMEZONE(TODAY(),'America/Los_Angeles'),'MM-DD-YYYY')
& " 12:00 PM",
'MM-DD-YYYY h:m A')
Someone might have a simpler & easier formula for this, but I just quickly whipped this together and it seems to work. You’ll want to choose your own timezone from the list of supported time zones.
DATETIME_PARSE(
DATETIME_FORMAT(SET_TIMEZONE(TODAY(),'America/Los_Angeles'),'MM-DD-YYYY')
& " 12:00 PM",
'MM-DD-YYYY h:m A')
That works quite well. The only thing that I can add is that with a simple format like that, you can actually leave out the formatting string in the DATETIME_PARSE()
function and it still parses correctly:
DATETIME_PARSE(
DATETIME_FORMAT(SET_TIMEZONE(TODAY(),'America/Los_Angeles'),'MM-DD-YYYY')
& " 12:00 PM")
I find that specific formatting strings are really only needed when the source string format is non-standard; e.g. “Jan252022”.
That works quite well. The only thing that I can add is that with a simple format like that, you can actually leave out the formatting string in the DATETIME_PARSE()
function and it still parses correctly:
DATETIME_PARSE(
DATETIME_FORMAT(SET_TIMEZONE(TODAY(),'America/Los_Angeles'),'MM-DD-YYYY')
& " 12:00 PM")
I find that specific formatting strings are really only needed when the source string format is non-standard; e.g. “Jan252022”.
Thanks, @Justin_Barrett! That’s great to know, and it’s a great simplification!