cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rachyett
Level: Powered On

Re: How do I get my dataform to display dates in DD/MM/YYYY format?

Hi aeMadhavan , I'm afraid 

 

Text(Today(), "[$-en-US]mm/dd/yyyy", "it-IT")

 

this doesn't work for me either.

I'm starting to think it may be a different problem, because the control, once unlocked is not showing today's date, but some random date in US format, by random I mean not todays date and not the date of the underlying list column.

 

So exactly where should I be putting "Text(Today(), "[$-en-US]mm/dd/yyyy", "it-IT")"  ?

Once i unlock the control, I've tried putting the formula in Card=>DataField in place of the lists column name just to see if it works

I've tried putting it in  DatePicker=>DefaultDate in place of Parent.Default 

I've tried putting it in both

 

None of the above results in anything other than a random date in US format.

 

Device and Browser settings are both UK, Region settings for underlying sharepoint site are UK

JRaasumaa
Level 10

Re: How do I get my dataform to display dates in DD/MM/YYYY format?


@rachyett wrote:

Hi aeMadhavan , I'm afraid 

 

Text(Today(), "[$-en-US]mm/dd/yyyy", "it-IT")

 

this doesn't work for me either.

I'm starting to think it may be a different problem, because the control, once unlocked is not showing today's date, but some random date in US format, by random I mean not todays date and not the date of the underlying list column.

 

So exactly where should I be putting "Text(Today(), "[$-en-US]mm/dd/yyyy", "it-IT")"  ?

Once i unlock the control, I've tried putting the formula in Card=>DataField in place of the lists column name just to see if it works

I've tried putting it in  DatePicker=>DefaultDate in place of Parent.Default 

I've tried putting it in both

 

None of the above results in anything other than a random date in US format.

 

Device and Browser settings are both UK, Region settings for underlying sharepoint site are UK


 

From another post I had: 

 

Wrap the date with a DateValue and a different timezone.

 

 

DateValue(YourDateFieldHere.Text,"fr")

You can then convert it around to another format like:

 

Text(DateValue(YourDateFieldHere.Text,"fr"),"dd/mm/yyyy")

 

 

 

Anonymous
Not applicable

Re: How do I get my dataform to display dates in DD/MM/YYYY format?

Hi @JRaasumaa,

 

please see the attachment that has the screenshot

Highlighted
KOM_4410
Level 8

Re: How do I get my dataform to display dates in DD/MM/YYYY format?

Not sure if you already solve this. But this worked for me when I had the same problem to display a date field with the right format

 

On the text property: Text(DateTimeValue(Parent.Default),"[$-en-US]dd/mm/yyyy")

 

Now, to use on a date picker, you change the Format property to:

 

Text(DatePicker1.SelectedDate,"[$-en-US]dd/mm/yyyy")

Anonymous
Not applicable

Re: How do I get my dataform to display dates in DD/MM/YYYY format?

Hi @KOM_4410,

 

Solved by using this Text(InvoiceDate,"[$-en-US]dd/mm/yyy","en-GB"). Thank you

rachyett
Level: Powered On

Re: How do I get my dataform to display dates in DD/MM/YYYY format?

Tried the three solutions listed above, all slightly different, but none of them work for me

I've tried creating dummy lists, with simple list names, in case there was some floor in my original example, I've tried on different machines in different locations with different operating systems and different browsers, but nothing I do changes the date from appearing in the power apps in the US format.  

rachyett
Level: Powered On

Re: How do I get my dataform to display dates in DD/MM/YYYY format?

@KOM_4410 @Anonymous @JRaasumaa

 

Tried the three solutions listed above, all slightly different, but none of them work for me

I've tried creating dummy lists, with simple list names, in case there was some floor in my original example, I've tried on different machines in different locations with different operating systems and different browsers, but nothing I do changes the date from appearing in the power apps in the US format.  

KOM_4410
Level 8

Re: How do I get my dataform to display dates in DD/MM/YYYY format?

Hi @rachyett,

 

Can you share some screenshots with the formulas and the properties you are using? It may help to find the problem

 

Cheers

harzicn
Level: Powered On

Re: How do I get my dataform to display dates in DD/MM/YYYY format?

Thank you. This is the solution that worked for me.

sanrajbhar
Level: Powered On

Re: How do I get my dataform to display dates in DD/MM/YYYY format?

this would work with LabelMan Happy

 

Text(DateTimeValue(Parent.Default),"dd/mm/yyy")

 

Helpful resources

Announcements
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (7,165)