Help

Automation: Creating Date and Time Zone

Topic Labels: Dates & Timezones
Solved
Jump to Solution
816 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Aileen_Wang
4 - Data Explorer
4 - Data Explorer

Hi, everyone.
Screen Shot 2021-08-19 at 2.44.33 PM

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
Screen Shot 2021-08-19 at 2.45.14 PM

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

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")

See Solution in Thread

1 Reply 1
Justin_Barrett
18 - Pluto
18 - Pluto

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")