+4I have a formula field that uses DATEADD to subtract 2 weeks from a date in another field. It produces the right date, but that date is formatted in a way that’s hard to read. Is it possible to configure the formatting so it shows up as MM/DD/YYYY ?
Screenshot to show how the formatting shows up in an email automation. It’s the internal due date that I’d like to format. differently.
Somwhat related, I’d like the ‘application due date’ to format as MM/DD/YYYY as well, if possible.
+32Try using DATETIME_FORMAT on the result of the DATEADD?
DATETIME_FORMAT(
DATEADD(
Date,
-2,
'weeks'
),
'MM/DD/YYYY'
)
+35
Check out the “formatting” tab of your formula field.
See screenshot below.
- ScottWorld, Expert Airtable Consultant
I’ll second what everyone else here has said. One other thing I will do if the time isn’t important is I switch off the “Include Time” option on the formatting tab. That’s helped me a lot in getting the correct formatting as well
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
