help with fillout date format

[ydoc]

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.

[TheTimeSavingCo · Accepted solution]

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

 

[ScottWorld · Accepted solution]

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