Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 04, 2024 12:06 PM
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! Go to Solution.
Aug 04, 2024 08:45 PM
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"
)
Aug 04, 2024 11:38 PM
In 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
Aug 04, 2024 08:45 PM
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"
)
Aug 04, 2024 11:38 PM
In 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