Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula with today() and a set time

Topic Labels: Formulas
2346 3
cancel
Showing results for 
Search instead for 
Did you mean: 
MattWeber
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey there…look for assistance with formula that uses the TODAY() function with a set time. I.e. I want the field to have the current date but with a set time so that it would show for example the current date that updates each day but always has 12:00 PM.

Thanks in advance for help

3 Replies 3

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”.

Thanks, @Justin_Barrett! That’s great to know, and it’s a great simplification! :slightly_smiling_face: