Hello I have an app built which is all good except for the fact that the date format does not replicate back to the excel sheet? Any ideas?
I did the following and it seemed to work.
Are you formatting all of the cells in the Excel worksheet โDate Installedโ column as โDateโ?
I ask because the number you are seeing in the โDate Installedโ column, is Excelโs native date format. Excel stores dates as the number of days since Jan 1, 1900. For example, Jan 31, 1900 is stored as 31, Feb 1, 1900 is stored as 32, and so on. The numbers you are seeing are the number of days between Jan , 1900 and the date value you are entering.
If you do not format the field as a date in Excel, you will simply see the numbers of days between Jan 1, 1900 and the date you entered stored as a number. Excel will only display the cell values as dates, if you format the cells
as โDateโ.
This article should help help.appsheet.com - Locale Support in AppSheet
If not, please provide more details regarding the problem. Locale Support in AppSheet help.appsheet.com
@Philip_Garrett_Appsh thanks Phil. I cannnot solve my issue. I enter the date of 19/02/2018 in my app and it shows as 43150 in my excel sheet. If I format the row in the sheet the date reads ok but it defaults back to 43150 each time I open it
Can you provide: 1. Your account Id from the Account pane 2. The app name 3 The table name 4. The column name
That will enable us at look at the the app.
tim@tjops.net.au Gateway SIT 10-Cable Date Installed
It appeared to work for me.
Here is what I did: 1. I opened the app. 2. I went to view โSIT-10โ 3. I selected the record with the STATIONS-FROM-TO value of โ646 - 645โ. 4. I clicked Update and entered only the required fields. I entered the current date in โDate Installedโ. I entered โtestingโ in the โInstalled byโ column so you can identify the row and undo the update once we figure out the problem. 5. I saved the change. 6. The change appeared in row 5 of the worksheet in the โDate Installedโ in the format
Can you give me the exact steps to reproduce the problem? I may not be doing what you are doing?
I spoke too soon. I think I see what you are reporting. Is the problem that the date appears as a number in the worksheet column?
@Philip_Garrett_Appsh correct. In the excel sheet in my google drive folder
Thanks Tim.
Let me look deeper. Not sure how long this will take.
For some reason my sheet will not save the format. Every time I change and save the format it defaults back to text?
User | Count |
---|---|
43 | |
29 | |
23 | |
21 | |
13 |