Power Apps

Date in UK format

(2) Share

Report

Posted on by nick9one1

303

I have a flow with a UK date string dd/mm/yyyy e.g. '29/01/2025'

I need to convert this to the format yyyy-MM-dd e.g. 2025-01-29

If I use

=Text(DateValue("29/01/2024"), "yyyy-mm-dd")

I get an error ' date cannot be parsed'. I think this is because it is expecting mm/dd/yyyy.

So how can I convert the string '29/01/2025' to 2025-01-29 using powerfx?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Daniel Bocklandt 5,117 Super User 2025 Season 2 on at

Like (0)

Report
Hey @nick9one1,

Yes there seems to be a bug in the DateValue function. It gives another date.
Here's a way to do it without this function.

With( { Datesplit: Split( "29/01/2025", "/" ) }, Text( Date( Last(Datesplit).Value, First( LastN( Datesplit, 2 ) ).Value, First(Datesplit).Value ), "yyyy-mm-dd" ) )

Let me know if it helped you.

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!

Was this reply helpful? Yes No
timl 36,415 Super User 2025 Season 2 on at

Like (1)

Report
Hi @nick9one1

Since your input is in UK format, the safest way to do this is to specify the "en-GB" locale like so.

That should hopefully resolve this issue.

Text(DateValue("29/01/2024","en-GB"), "yyyy-mm-dd")

Was this reply helpful? Yes No
Nirav Raval (Akira28) 153 Moderator on at

Like (0)

Report
Hi nick9one1 ,

Try below formula and check

Text(DateValue(Mid("29/01/2025", 4, 2) & "/" & Left("29/01/2025", 2) & "/" & Right("29/01/2025", 4)), "yyyy-MM-dd")

If this post solved your issue, clicking 'Does this answer your question' will help others discover the solution and close the topic. If you found it helpful, a Like would be awesome!

Regards,
Nirav J Raval (Akira28) 🤞

Was this reply helpful? Yes No
timl 36,415 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Nirav (Akira28)

The formula that you posted converts the input value to mm/dd/yyyy and passes it to DateValue.

This won't work in the UK because the expected format is dd/mm/yyyy.

As the screenshot below highlights, parsing this incorrect format in a UK setup produces the incorrect result of '2027-05-01'.

For users in the UK, the best approach is to include the "en-GB" specifier which will ensure that the date is properly parsed in UK format, as shown below.

Was this reply helpful? Yes No