Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: help with fillout date format

Solved
Jump to Solution
1069 0
cancel
Showing results for 
Search instead for 
Did you mean: 
ydoc
5 - Automation Enthusiast
5 - Automation Enthusiast
 

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.

2 Solutions

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2024-08-05 at 11.44.52 AM.png

Screenshot 2024-08-05 at 11.45.00 AM.png

See Solution in Thread

ScottWorld
18 - Pluto
18 - Pluto

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

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2024-08-05 at 11.44.52 AM.png

Screenshot 2024-08-05 at 11.45.00 AM.png

ScottWorld
18 - Pluto
18 - Pluto

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