Answered

Datepicker Bug?

(0) Share

Report

Posted on by leyburn19

2,157

If I make the DatePicker is editable and patch an entered date the result is always blank. If I select the date from it picker it selects and patches the correct date. If I edit the date in a datepicker by simple type over the result returns blank, not the new date. Is this a bug or am I missing a setting somewhere.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@leyburn19

I was able to patch to a collection without issue, ie

Patch( colDates, Defaults(colDates), { ID: Value(TextInput1.Text), sel_date: DatePicker1.SelectedDate } )

However, If I tried entering dates like 3/5/21 by typing it would patch blanks. Seems it maybe tied to the Format property? Testing I tried by typing in Dates:

Set Format to: "dd/mm/yyyy"

Patch Date: 5/3/2021 --> works fine

Patch Date: 5/3/21 --> Patches a blank

Set Format to: "dd/mm/yy"

Patch Date: 5/3/2021 --> Patches a blank

Patch Date: 5/3/21 --> works fine

For both the above Format settings, Patch worked fine when selecting from Date Picker.

I guess the other thing to consider is a data source issue, I've just used a collection here.
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous you can always add a check to your code for him to check format if it typed before writing the patched. Just off hand, not on my pc to write it out and make sure it works, but id say you could do a split on "/" then count characters of last section and if is not 4 add the 20 to it then reassemble the date for patching. Ofcourse you would need to update it in like 79 years when we hit 2100 hah
Verified answer

leyburn19 2,157 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks all. the problem was associated with the Date Format. I had somehow typed dd/mm/yyy instead of dd/mm/yyyy. The three Y caused the problem
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @leyburn19 ,

Has your problem been resolved?

If so , you could mark your reply as a solution.

Thanks.

Best Regards,

Wearsky