A few days ago I set my app up to submit some data including a date stamp to an Excel file. Without making any additional changes to my app, it seems to have switched which format the date is stored in, which has thrown a monkey wrench into how I display that date going forward.
My form has a DatePicker which defaults to Today(). When I initially created my App 2 days ago, it was storing the date in the following format:
2021-10-08T07:00:00.000Z
This date/time format was recognized by other aspects of my app. For example, I have a gallery which shows the date stamp with the following formula:
Text(ThisItem.'Date Created',DateTimeFormat.ShortDate)
Which correctly showed the above date as "10/8/21".
Today (2 days later), I opened up my project without making any edits, and everything seems broken?
In my gallery, the date is now being displayed as "2021-10-08T07:00:00.000Z" instead of "10/8/21".
Also when I try to submit a new entry, the stored data format has been changed to this:
1633849200000
But the kicker is; my app doesn't even recognize this new number as a date format... Viewing this new entry on my gallery, it will show the date as "1633849200000"...
And as mentioned above, the original entries are still not being shown as a short date. They're just pulling through as the raw data (despite the Text formula with a date format).
