web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Format a Date dd.mm.yy...

Power Apps

Suggested Answer

Format a Date dd.mm.yyyy into yyyy-mm-dd in power Apps

(1) Share

Report

Report

Posted on by Looky_123

8

Hello Everybody

I am trying to format a date from dd.mm.yyyy into yyyy-mm-dd.

I found the following formula on the internet, but it does not work.

DateValue(DataCardValue.SelectedDate; "yyyy/mm/dd")

Can anyone help me?

Thank you in advance

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

abc 123 789 Moderator on at

Like (0)

Report
Copy link

Link copied!

//Use intrinsic date formats based on region

UpdateContext({strWrongFormat: "04.10.2024"});

UpdateContext({dtmRightFormatEn: DateValue(strWrongFormat,"en") });

//Take full control

UpdateContext({strDay: Left(strWrongFormat,2)});

UpdateContext({strMonth: Mid(strWrongFormat,4,2)});

UpdateContext({strYear: Right(strWrongFormat,4)});

UpdateContext({dtmRightFormatCustom: DateValue(strMonth & "/" & strDay & "/" & strYear) });

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
If the DataCardValue is a date picker control (that already gives you the a date value), then you can use the Text function to format it as you want:

Text( DataCardValue.SelectedDate, "yyyy-mm-dd" )

If the date you have is a text value, then you can use the DateValue function to convert that into a date value. The second argument of DateValue is a locale, and the date will be parsed in that locale. In "dd.mm.yyyy" is the default format for the de-DE locale, so you can use an expression like the following:
Text( DateValue(<your date as text>, "de-DE"), "yyyy-mm-dd" )
Hope this helps!

Was this reply helpful? Yes No

Join the conversation