Strange data display in concatenated date field

I have a field with an app formula that is suddenly not displaying correctly even though the data is being stored correctly in the underlying sheet. I don’t think I changed anything.

Old data displays properly. Today’s data does not. Instead of Jul 23 it shows 44400

Screen Shot 2021-07-23 at 7.59.27 AM

This is the app formula. It correctly formats the date in the underlying data.

The underlying data is correct but is not displaying correctly.
Screen Shot 2021-07-23 at 7.57.05 AM

Any ideas?

Update. When it first processes it shows the correct format. THEN it switches to 44400. I have a video of that but don’t think I can upload it.

1 Like

What is displayed in date format is actually a numeric value. The number 1 denotes the year 12.31.1899. 44400 refers to the year 23 July 2021.

Set the cell format in the underlying data back to date format.
I’m not sure if it’s a complete solution. Worth to try.

2 Likes

Try changing the format to text in your google sheets.

2 Likes