cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Re: DateTime picker displays incorrect format for our region

I changed it to Text(Parent.Default,"[$-en-GB]dd/mm/yyyy","en-GB") and still got 5/2/2018, which I changed to another date to see what it would do, and the date in sharePoint wasn't the same. Hmmm no joy.

 

Sorry was a typo on my end with the 3 y's I did actually change it to 4

 

 

Meneghino
Level 10

Re: DateTime picker displays incorrect format for our region

OK, I give up.  In any case what I do in my work is not to use date or date/time columns at all and use either:

 

A) A text column where I place yyyy-mm-dd or yyyy-mm-dd hh:mm

B) An integer column where I place year*10000+month*100+day

 

I then parse back and forth in PowerApps.  This resolves any time zone, server time, locale issues but is obviously a little more work, but not much.

Highlighted
Victoria
Level 8

Re: DateTime picker displays incorrect format for our region

Has anyone managed to resolve this? I have tried all of this and NOTHING WORKS.

Despite regional settings in Office, SharePoint and browsers all set to UK, the picker is still displaying in US format. It's confusing for my users.

 

Is there any way to remove the picker display text?


TopShelf-MSFT
Level 10

Re: DateTime picker displays incorrect format for our region

hi all, 

 

the following blog post has helped users in past threads with datetime picker display issues. I will include it below. If this does not solve your query, please let me know and I will investigate further. 

 

https://powerapps.microsoft.com/en-us/blog/working-with-datetime-values-in-sql/ 

 

@TopShelf-MSFT

Aliaduoo
Level: Power Up

Re: DateTime picker displays incorrect format for our region

Just found the solution here.

 

 

MattyH
Level 8

Re: DateTime picker displays incorrect format for our region

The formula below works for me, showing dates in UK format, that would otherwise show in US format.

 

Text(DateTimeValue(Parent.Default),"[$-en-US]dd/mm/yyyy")

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,487)