Today, when submitting a form that has a date field, you must make sure to use the American standard: mm-dd-mm-yyyy (if you type the date instead of selecting directly from the calendar) However, it would be nice if the portal/form creators had the possibility to set the date standard - for example…

Hello, @amanda.teodoro . To have the dd-mm-yyyy format in your form, you need to use the European format in the Airtable. Same goes for the time zone setup. We have a step-by-step guide that will help you change the date format in Airtable. You can check it out here: Step-by-step changing of the date…

Hi, @Abdul ! Does this work only in the European format? I ask this because sometimes, depending on the time of day you submit the form, the day is automatically set as the next day. This happens because we are from Brazil (GMT-3). Because of this, we have set Airtable’s date format to “Local”: […

Hi @amanda.teodoro . The date format is independent setup from time zone. Let’s discuss about the issue that you encounter. Are you using this feature? [image]

So for example, you set 01/05/2023 for the date field and upon checking in Airtable, it shows up as 02/05/2023. You are in GMT-3 timezone as you mention. I assume that the date field in Airtable is using America/Sao_Paulo time zone based on your screenshot. Can you confirm?

Hi @Abdul ! I changed all my fields in Airtable to the same time zone and it seems that the problem was solved. So, would it be possible to just provide the possibility to adjust the language of the forms/portals to Portuguese? Thanks!

At the moment, this is not possible. A ticket has been created after you have sent your first request. We will keep you updated with on the progress.

Are there some updates? I have the same need as Amanda.

Set Date Format and Time Zone

Feature Requests

amanda.teodoro May 2, 2023, 8:44pm 5

Hi @Abdul! No, we are not using this feature. We put the date as a required field instead.

Topic		Replies	Views
Portuguese language for forms & portals Feature Requests	3	234	May 12, 2023
Dates showing wrong on Grid view after daylight savings Need help	5	165	February 6, 2024
Language: Portuguese is now available New Releases	6	171	June 11, 2023
Default Date Field with Today Feature Requests	1	83	April 30, 2024
Dynamic Default Date Values Feature Requests	2	29	September 30, 2024

Set Date Format and Time Zone

Related topics