# Set Date Format and Time Zone

**URL:** <https://community.miniextensions.com/t/set-date-format-and-time-zone/215>\
**Category:** Feature Requests\
**Created:** [April 27, 2023, 6:33pm UTC](https://community.miniextensions.com/t/set-date-format-and-time-zone/215 "2023-04-27T18:33:26Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![amanda.teodoro](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.miniextensions.com/amanda.teodoro/32/593_2.png) [@amanda.teodoro](https://community.miniextensions.com/u/amanda.teodoro)\
**Post date:** [April 27, 2023, 6:33pm UTC](https://community.miniextensions.com/t/set-date-format-and-time-zone/215/1 "2023-04-27T18:33:26Z")

</div>

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 dd-mm-yyyy - and also the time zone.

---

<div class="post-metadata">

**Author:** ![Abdul](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Abdul](https://community.miniextensions.com/u/Abdul)\
**Post date:** [April 28, 2023, 3:21pm UTC](https://community.miniextensions.com/t/set-date-format-and-time-zone/215/2 "2023-04-28T15:21:16Z")

</div>

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 format in Airtable](https://docs.miniextensions.com/en/articles/7834263)

---

<div class="post-metadata">

**Author:** ![amanda.teodoro](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.miniextensions.com/amanda.teodoro/32/593_2.png) [@amanda.teodoro](https://community.miniextensions.com/u/amanda.teodoro)\
**Post date:** [April 28, 2023, 6:27pm UTC](https://community.miniextensions.com/t/set-date-format-and-time-zone/215/3 "2023-04-28T18:27:51Z")

</div>

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”:

![Print - Date Format - Sao Paulo - Brazil](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/ecc68d76675621a9823e1ef3ec9c5bb9ecd41a86.png)

Note: it would also be very nice if we could set the language to Portuguese.

---

<div class="post-metadata">

**Author:** ![Abdul](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Abdul](https://community.miniextensions.com/u/Abdul)\
**Post date:** [April 30, 2023, 5:56am UTC](https://community.miniextensions.com/t/set-date-format-and-time-zone/215/4 "2023-04-30T05:56:46Z")

</div>

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](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/91b0113f13a6618a74349fd4b54291eba0b52054.png)

---

<div class="post-metadata">

**Author:** ![amanda.teodoro](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.miniextensions.com/amanda.teodoro/32/593_2.png) [@amanda.teodoro](https://community.miniextensions.com/u/amanda.teodoro)\
**Post date:** [May 2, 2023, 8:44pm UTC](https://community.miniextensions.com/t/set-date-format-and-time-zone/215/5 "2023-05-02T20:44:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Abdul](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Abdul](https://community.miniextensions.com/u/Abdul)\
**Post date:** [May 3, 2023, 8:34am UTC](https://community.miniextensions.com/t/set-date-format-and-time-zone/215/6 "2023-05-03T08:34:53Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![amanda.teodoro](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.miniextensions.com/amanda.teodoro/32/593_2.png) [@amanda.teodoro](https://community.miniextensions.com/u/amanda.teodoro)\
**Post date:** [May 9, 2023, 4:40pm UTC](https://community.miniextensions.com/t/set-date-format-and-time-zone/215/7 "2023-05-09T16:40:01Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![Abdul](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Abdul](https://community.miniextensions.com/u/Abdul)\
**Post date:** [May 9, 2023, 4:56pm UTC](https://community.miniextensions.com/t/set-date-format-and-time-zone/215/8 "2023-05-09T16:56:16Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![oleksust](https://avatars.discourse-cdn.com/v4/letter/o/e99b99/32.png) [@oleksust](https://community.miniextensions.com/u/oleksust)\
**Post date:** [May 2, 2024, 11:29pm UTC](https://community.miniextensions.com/t/set-date-format-and-time-zone/215/9 "2024-05-02T23:29:48Z")

</div>

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