Question

How to configure Google Sheet to keep the format MM-DD-YYYY?

  • 8 August 2023
  • 2 replies
  • 57 views

Hello 

le format date MM-DD-YYYY est envoyé dans un champ de Google Sheet (GS), mais il est mal interprété en DD-MM-YYYY sur GS (Format de cellule précisé plus bas) 

Comment paramétrer Google Sheet pour conserver le format MM-DD-YYYY ?

Sur GS j’ai choisi le format : MM-DD-YYYY

Merci pour votre aide 

Seb


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @Seb_RTC 

Translated to English with Google Translate:

 

the date format MM-DD-YYYY is sent in a Google Sheet (GS) field, but it is misinterpreted as DD-MM-YYYY on GS (cell format specified below)

How to configure Google Sheet to keep the format MM-DD-YYYY?

On GS I chose the format: MM-DD-YYYY

Thanks for your help

Userlevel 7
Badge +14

@Seb_RTC 

Check the GSheet Settings

Location: GSheet > File > Settings

 

###

 

A different approach would be to use Airtable instead of GSheets.

Airtable has a standardized Date field.