hello in my app i have a field date. users c...

[Thierry_BODIN]

hello

in my app i have a field date. users can write a date in french format (day/month/year) in my spreadsheet there’s existant datas with only year format but in this format the app write a complete date i.e if it’s 2000 it will appear 22/6/1905 certainly date number can i modify app to read many date’s format andmodify in the right format ? thanks

[Aleksi_Alkio]

I’m afraid you can use only one format with one column.

[Thierry_BODIN]

ok so i will have to modify dates in my spreadsheet to be in right format. thanks