Skip to main content

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

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


@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.