Unanswered

Date Time weirdness

(0) Share

Report

Posted on by robinisathakur

I've got a PowerApp I'm building in the UK with UK date time formats. I've added a date time picker on the form for a text field, and the date picker displays in uk format (mm/dd/yyyy). On an new item, when it saves back to the text field in SP it does it in UK format. All good

However, If I reopen the form in edit mode for an existing item, the date selected by the date field is completely wrong. For example 13/05/2021 stored in the text field results in the date picker defaulting to 05/01/2022

I've set the format of the Date Picker to be dd/mm/yyyy

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
Re: Date Time weirdness

Hi @robinisathakur :

please set the data card's Update property to

Text(DatePicker.SelectedDate,"dd/mm/yyyy")

and then set the data picker's DefaultDate property to :

DateValue(Parent.Default,"en-GB")

Best Regards,

Bof

Was this reply helpful? Yes No
robinisathakur on at

Like (0)

Report

Re: Date Time weirdness

Thanks, it was simpler than I was trying to do it, and you saved my bacon!

Was this reply helpful? Yes No