I have an issue with the way AppSheet formats a date with the TODAY() function.
I use TODAY() in a workflow in order to create a new folder based on the current day, in OneDrive. Here, OneDrive seems to format the date automatically to DD-MM-YYYY i.e. 24-02-2020. This is fine.
I also use TODAY() to create a filepath to the same folder, but as this is stored in the spreadsheet AppSheet seems to work with (D)D.(M)M.YYYY i.e. 24.2.2020.
I fixed the dots by using SUBSTITUTE to replace dots with dashes but then I still get 24-2-2020, when I need it to be 24-02-2020. I guess I could use SUBSTITUTE() for this as well, but then Iโd have to make a case for all the days and months where I need to add a 0, no?
The spreadsheet is in Excel, but the formatting doesnโt seem to happen on the spreadsheet level, at least not at a quick glance.
Any help is appreciated!
Solved! Go to Solution.
I believe default date formatting is for AppSheet is determined by the locale of the device, and thatโs it. But luckily for you, you can just wrap TODAY() in a TEXT() formatting.
TEXT(TODAY(),"DD-MM-YYYY")
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |