Hi guys,
I have a very annoying issue when inputting dates using a date picker.
When i input a date, The information initially is saved in my Excel table in a date format "02 10 2020 22:00:00". Its not perfect as I want the date to be a local date (I'm 2 hrs before GMT), but i can work with it (this issue is for another thread).
Here comes the problem: After a number of entries are imputted, the data then changes to ISO 8601 format "2020-10-02T22:00:00.000Z" and the format in my excel column changes to general!?! Then all information is not readable as its now text format and the data will no longer display in the app.
Please can someone help me solve the issue, and keep the data format constant.
Thanks in advance!
I think that has solved the problem! I now get the ISO 8601 format. AND it seems to be reading back into the app.
Thanks so much!
Hi @RyanOConnor
Yes, Is possible,
For saves the date in text formate you can do like that.
Text(DatePicker1.SelectedDate)
Thanks,
Hi Vijay,
How would I save the date entry as text into excel? I created the date picker using a form from the excel sheet. I want the date picker to remain if possible.
Thanks a lot
Hi @RyanOConnor ,
For this requirement, You can save the date into excel as text. and when you reading into the app then use like DateValue(DateText).
This will help you to maintain the date formate properly as per your requirement.
Thanks,
Vijay
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional