Automation: Creating Date and Time Zone

Hi, everyone.

I’m wondering if there’s a way for me to adjust the date and time in the following format: [MM/DD/YYYY XX:XXpm] for Slack and Email. I can’t seem to do that in the automation box. Would I need to insert a formula or some other solution?

Thanks.

Screen Shot 2021-08-19 at 2.44.42 PM

Yes, you’ll need a formula field to format the date, and then you’ll use the output of that field in your automation. What you’re currently seeing is the default output when converting a datetime—the data stored by a date field or any field producing a date—into a string. This formula should work:

DATETIME_FORMAT({Submitted Date}, "MM/DD/YYYY hh:mma")

Note that using this formula would show the captured date based on GMT because that’s how the data is stored under the hood. If you’d like to format the date based on your local timezone, use this formula, replacing TIMEZONE with your local timezone specifier from this list.

DATETIME_FORMAT(SET_TIMEZONE({Submitted Date}, "TIMEZONE"), "MM/DD/YYYY hh:mma")
1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.