Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Automation: Creating Date and Time Zone

Topic Labels: Dates & Timezones
Solved
Jump to Solution
325 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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