News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Date Time weirdness

Power Apps - Building Power Apps

Answered

Date Time weirdness

(0) Share

Report

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

All responses Img

All responses (2)

Answers Img

Answers (1)

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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Give Back to the Community this Month

Quick Links

Leaderboard

#1

WarrenBelz 143,591

#2

RandyHayes 76,308

#3

Pstork1 64,090

Leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value

How to patch multiple records at once

Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans