Patching date time value to SharePoint column and month and day are reversed

(0) Share

Report

Posted on by BrendanZ1

333

Hi all,

Hoping someone can see a solution to this issue:

I have a date time column in SharePoint (Booked In Time) and regional settings are set to Australia with format of dd/mm/yyyy.

In my PowerApp, I am using a date picker with two dropdowns (for hours and minutes).

I have a label that displays with this code:

Text(DateValue1_4.SelectedDate, "dd-mm-yyyy") & " " & Text(HourValue1_4.Selected.Value, "00") & ":" & Text(MinuteValue1_4.Selected.Value, "00")

For the patch, I use the following to convert a text string to date time value: 'Booked Time In' DateTimeValue(lblDateTimeValueBooked.Text)

In SharePoint though, the column displays mm/dd/yyyy

Although the settings on the date picker shouldn't matter due to the string to date time conversion, I have the Language property as "en-AU" and the Format to "dd/mm/yyyy"

not sure why it won't maintain the correct format?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @BrendanZ1 ,

You gotta love US dates . . . however you already have the value you need to write back to a date/time field

DateValue1_4.SelectedDate + Time( Value(HourValue1_4.Selected.Value), Value(MinuteValue1_4.Selected.Value), 0 )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
BrendanZ1 333 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @WarrenBelz - did feel like it was a simple fix. All working now and yes I love US dates - they are the best......if you live there
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@BrendanZ1 ,

I have posted this one a few times before . . . .