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

DateAdd + Last Modified Time

Topic Labels: Dates & Timezones
428 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey Community,

I’m trying to create a formula to add 7 days to a {Date} and add the Last Modified time to the the end of the result. I am currently using this formula

DATEADD({Date}, 7,‘day’) & DATETIME_FORMAT({Last Modified}, ‘h:mm’)

but this is what I get back
example:

2021-12-07T00:00:00.000Z6:35

I have also tried adding

SET_TIMEZONE({Last Modified}, ‘America/Los_Angeles’

after the DateTime_Format but I am met with the same result. Would love some help please!

1 Reply 1

You’ll need to format both dates, not just the second one, and add a separating space between them.

DATETIME_FORMAT(DATEADD({Date}, 7, "day"), "L") & " " & DATETIME_FORMAT({Last Modified}, "h:mm")