DateTimeValue will not set as GB?

(0) Share

Report

Posted on by DavidMullett

Hi,

I have the following code but when I do it through the powerapp on a mobile device or accessing it directly it works fine however when I access through a Sharepoint site, even though the region is set to English UK, it thinks the 5/1/2022 is June!

Set(
 selectedDate,
 Calendar_1.StartDate
);
Set(
 selectedEndDate,
 Calendar_1.EndDate
);
Set(
 startTime,
 DateTimeValue(Text(
 selectedDate,
 "dd/mm/yyyy"
 ) & " " & ddTimeFrom.Selected.Value
 )
);
Set(
 endTime,
 If(
 DateValue(
 Text(
 selectedEndDate,
 "dd/mm/yyyy"
 )
 ) < DateValue(
 Text(
 selectedDate,
 "dd/mm/yyyy"
 )
 ),
 DateTimeValue(
 Text(
 selectedDate,
 "dd/mm/yyyy"
 ) & " " & ddTimeTo.Selected.Value
 ),
 DateTimeValue(
 Text(
 selectedEndDate,
 "dd/mm/yyyy"
 ) & " " & ddTimeTo.Selected.Value
 )
 )
);

How do I get the startTime to stick to dd/mm/yyyy ??

Thanks

David

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DavidMullett ,

You can try with below Approach.

You need to force the Variable also contains the Same formate you expect.

LIke below -

Set( selectedDate, DateTimeValue(Calendar_1.StartDate,"dd/MM/yyyy") ); Set( selectedEndDate, DateTimeValue(Calendar_1.EndDate,"dd/MM/yyyy") );

Was this reply helpful? Yes No