Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Request: Set Timezone for Date-only Datetime Fields

cancel
Showing results for 
Search instead for 
Did you mean: 
Joseph_Roza
8 - Airtable Astronomer
8 - Airtable Astronomer
Status: New Ideas
What is the proposed idea/solution?

Allow us to select a timezone for datetime fields that only show a date.

How does this solve the user problems?

There is currenly a disconnect between Interface date filters (ie. filter Where {Date Field} is Today) which will filter based on a local timezone, but inside the base, the date-only field is GMT. So, the interface will filter based on local timezone, but records in the base will be GMT-based dates, and will be filtered out, even if the date is the same as the local timezone.

How was this validated?

By beating my head into the brick-wall that is Date-based filters

Who is the target audience?

Anyone who uses the filter based on 'Today'.

1 Comment
Joseph_Roza
8 - Airtable Astronomer
8 - Airtable Astronomer

For anyone following, it appears date-only fields have a Display Time Zone toggle. You can't select the timezone yet, but it appears that's the direction things are moving.