Column Date Format

I’ve got 2 columns in the same Google spreadsheet tab / Appsheet Table. In the spreadsheet the date is shown differently:

[MaterialsCreation] has a inital value of Now() and shows the date as M/DD/YYYY

[MaterialsMod] Is a ChangeTimeStamp and shows the date as DD/MM/YYYY

The spreadsheet is set to UK and both columns are formatted as AUTO

Any ideas how to get the first column to use UK date formating? :slight_smile:

Could you please add where the dates show in the mentioned format ( M/DD/YYYY and DD/MM/YYYY) - In the app or the spreadsheet?

In general, I believe you could set the format of those two columns in the spreadsheet in DD/MM/YYYY date format instead of Auto by utilizing the options Format --> Number -> More Formats --> More Date and Time Formats

Hi @Suvrutt_Gurjar

The issue was in the spreadsheet. But formatting both columns worked fine. It was just weird they were identical but giving different results.

1 Like