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?
Solved! Go to Solution.
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
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
The issue was in the spreadsheet. But formatting both columns worked fine. It was just weird they were identical but giving different results.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |