How can I make it 2024-08-31 6:30 PM PDT like how the record is in my airtable base? I don't want that T or Z at the end and the seconds and the decimal to be shown either.
Solved
help with fillout date format
+5Best answer by TheTimeSavingCo
Try creating a formula field with DATETIME_FORMAT and SET_TIMEZONE and displaying that field:
https://support.airtable.com/docs/supported-timezones-for-set-timezone
DATETIME_FORMAT(
SET_TIMEZONE(
Date,
'America/Los_Angeles'
),
"LLL"
)
+31Try creating a formula field with DATETIME_FORMAT and SET_TIMEZONE and displaying that field:
https://support.airtable.com/docs/supported-timezones-for-set-timezone
DATETIME_FORMAT(
SET_TIMEZONE(
Date,
'America/Los_Angeles'
),
"LLL"
)
+35In addition to giving you the ability to display all the other Airtable field types (including attachment fields), Fillout’s advanced forms for Airtable also give you the special ability to display lookup fields, rollup fields, formula fields.
So in your case, you would just create a formula field in Airtable to display the date how you want, and then use that formula field in Fillout.
You typically won’t need to use the set_timezone function, especially if you set the formatting on your formula field to be the same for all users, but you can learn more about the DATETIME_FORMAT function here: https://support.airtable.com//docs/formula-field-reference
Hope this helps!
- ScottWorld, Expert Airtable Consultant
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.