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
a
(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
a
(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