# Mode "calendar" **URL:** \ **Category:** Feature Requests\ **Created:** [January 3, 2020, 5:44pm UTC](https://community.glideapps.com/t/mode-calendar/3307 "2020-01-03T17:44:37Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![D3k](https://avatars.discourse-cdn.com/v4/letter/d/b5a626/32.png) [@D3k](https://community.glideapps.com/u/D3k)\ **Post date:** [January 3, 2020, 5:44pm UTC](https://community.glideapps.com/t/mode-calendar/3307/1 "2020-01-03T17:44:37Z")
Hello Actualy I use the mode calendar. But we have problems in France On my google sheet i put the date with european system dd/mm/yy and on glide we see mm/dd/yy. Is it possible that the glide system use automatly the time’ system of the google sheet? thank you for help D3k ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 4, 2020, 3:38pm UTC](https://community.glideapps.com/t/mode-calendar/3307/2 "2020-01-04T15:38:50Z")
If you look at your spreadsheet settings, what is the locale for your sheet? I think it can determine how your sheet interprets dates, which will be translated to Glide properly. Also, the locale of your device and browser can make a difference. I’m still trying to understand all of this myself, but personally, if you are typing in the dates yourself, I think `YYYY/MM/DD` is a safer way to do it, because I think that format is recognized globally. Here is some documentation on dates: [https://docs.glideapps.com/all/reference/components/pickers/date-time#date-formats-and-locales](https://docs.glideapps.com/all/reference/components/pickers/date-time#date-formats-and-locales) ---
**Author:** ![Rosinda\_Anthony](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosinda_anthony/32/1099_2.png) [@Rosinda\_Anthony](https://community.glideapps.com/u/Rosinda_Anthony)\ **Post date:** [January 6, 2020, 12:40am UTC](https://community.glideapps.com/t/mode-calendar/3307/3 "2020-01-06T00:40:21Z")
@Jeff_Hager, what would be the solution if you’re in one time zone and date setting (e.g., New York, EST, MM/DD/YYYY), but you’re building an app for a client in a different time zone and date setting (e.g., Eastern Caribbean, AST, DD/MM/YYYY)? In this case, would there be an issue? I hope I’m making sense. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 6, 2020, 1:12am UTC](https://community.glideapps.com/t/mode-calendar/3307/4 "2020-01-06T01:12:06Z")
@Rosinda_Anthony where are your dates coming from? Are you entering them manually in the sheet, or are they coming from the app? If you are manually entering them in the sheet, then you should be safe entering them in YYYY/MM/DD format. If dates come from a date entry field in the app, then they are saved in the following format which is a universal date/time format: 2019-11-28T07:37:03.872Z. It may look like a normal date/time in your sheet that matches your locale, but behind the scenes it is stored in the format with the T and Z. From what I understand, you should be fine. ---
**Author:** ![Rosinda\_Anthony](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosinda_anthony/32/1099_2.png) [@Rosinda\_Anthony](https://community.glideapps.com/u/Rosinda_Anthony)\ **Post date:** [January 6, 2020, 2:07pm UTC](https://community.glideapps.com/t/mode-calendar/3307/5 "2020-01-06T14:07:25Z")
@Jeff_Hager, thank you!