Unanswered

Datepicker fun

(0) Share

Report

Posted on by ulfarh

Hi all, I have this very annoying issue with DatePicker, in that it displays a normal SQL Server datetime field (i.e. "dd.mm.yyyy") as "mm/dd/yyyy" and in the process changes the value, i.e. from "30.06.2020" to "06/06/2022". If the date part is below 13, then it displays the date normally, as you can see in the below screenshot. I've tried to change the language and format options of the Datepicker, to no avail. Any ideas what I'm doing wrong?

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Please is your SQL Date, DateTime or just Date. I suggest it should be DateTime (Much longer than "30.06.2020")
Also is the DatePicker connected to the SQL Date column?
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
ulfarh 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Eka

Yes the SQL field is a datetime field (not using the time portion, so full value of field is '2020-06-30 00:00:00.000'). I've tried connecting the DatePicker directly to the SQL field and also tried putting the value into a label and format the label differently. No luck... 😞
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Did you put the formula "dd.mm.yyyy" in the Format of the DatePicker? because I am not getting same.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
ulfarh 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes I did. What I get then is a "06.06.2022". And since what I was expecting was "30.06.2020" I'm obviously perplexed. So the problem seems to be that the date picker is adding almost two years to the date! It's as if it's adding 24 months (i.e. 30-6)????
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Am not sure how you get the date in the Datepicker. Do you just select the date from the datepicker or you have connected the Datepicker to a textbox?
Can you explain
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
ulfarh 6 on at

Like
a
(0)

Report
Copy link

Link copied!

I populated a collection with data from SQL server table and set the default value of the datepicker to the datetime field of the collection column. Nothing more complex than that.