Issues with Date Picker changing the date format in randomly

Like (0) Share

Report

Posted on 9 Oct 2020 09:46:17 by RyanOConnor

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!

Categories:

General Questions

Connecting to Data

All responses (4)

Answers (1)

RyanOConnor 9 on 09 Oct 2020 at 11:14:21

Like (1)

Report

Re: Issues with Date Picker changing the date format in randomly

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!
Verified answer

Vijay Tailor 2,961 on 09 Oct 2020 at 10:33:16

Like (1)

Report
Re: Issues with Date Picker changing the date format in randomly

Hi @RyanOConnor
Yes, Is possible,

For saves the date in text formate you can do like that.
Text(DatePicker1.SelectedDate)

Thanks,
RyanOConnor 9 on 09 Oct 2020 at 10:19:11

Like (0)

Report

Re: Issues with Date Picker changing the date format in randomly

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
Vijay Tailor 2,961 on 09 Oct 2020 at 09:59:00

Like (0)

Report

Re: Issues with Date Picker changing the date format in randomly

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