Answered

Date format showing US date format for some users. How to fix back to UK date format?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

This is quite odd I and viewing the date format in my powerapp as DD/MM/YYYY and other users are getting MM/DD/YYYY.

I have an indicator attached to this date format and for the users with the US format the indicator does not work properly. (see 2nd attached image). mine is working fine.

I've tried this: Text(ThisItem.StartDate,"[$-en-UK]dd/mm/yyyy") and Text(ThisItem.EndDate,"[$-en-UK]dd/mm/yyyy") with no luck.

in the below example I've set the date for 01/10/2023 to 25/10/2023. This has turned their indicator into 10/01/2023 to 10/25/2023 which does not work as per the image.

I have checked the users date and time settings, and they all look the same pointing to Uk and Australian.

Any help would be greatly appreciated.

Categories:

Building Power Apps

All responses (15)

Answers (1)

Sort by

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

If that is on a Label and inside a Form or a Gallery then

Text(ThisItem.StartDate,"dd/mm/yyyy")

should work. What is your data source ?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz the Data source is a SharePoint list. which I have connected via Collect(TaskList,
{
ID: Round(Rand()*10000,0),
StartDate: StartDate.SelectedDate,
EndDate: EndDate.SelectedDate
}

And a Patch similar to the above.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I should mention some users are going direct to the SP list and manually adding the data.
WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

Something that needs changing is the names on your date pickers are the same as the field names, which can cause ambiguity. I suggest you change the field names in the collection and see if that makes a difference.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Okay, i'll give it a go and let you know.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz is there a way to make the date format enforced in this bit of code: DateDiff(Date(2023,1,1), DateValue(_StartDate.Text ))+1
WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

That code will return a number of days, not a date - what does _StartDate.Text look like ?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

it looks like this: Text(ThisItem.StartDate,"dd/mm/yy")
WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

The issue with that is how do you enforce anything with a day 12 and under ?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry I'm not providing any context so I will start again.

I have made a Gantt calendar view which uses the X position and label width to show the user where in time the specific topic is happening.

The idcator/label has this in it's X value: Value(StartDays.Text) * GanttTasks.Width / 365
in the width: (Value(EndDays.Text) - Value(StartDays.Text)) * GanttTasks.Width / 365
The StartDays have this: DateDiff(Date(2023,1,1), DateValue(_StartDate.Text ))+1
And, EndDays have this DateDiff(Date(2023,1,1), DateValue(_EndDate.Text))+1
The _StartDate and _EndDate both use this format: Text(ThisItem.EndDate,"dd/mm/yy")

The issue that I am facing is that some users see that above date format as reversed, or in the US format which is: mm/dd/yy. I'm told this is because of their win365 date configuration...

Is there a way to force just one date format in the X position and width?

Thanks,
Phil