Convert date format in Powerapps

(1) Share

Report

Posted on by CU03051719-0

I want to convert data format in powerapps screen becz database stores in different format.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @CU03051719-0,

a couple of quick questions:

What format is the date stored in your database (e.g. "2026-06-07", "07/06/2026", a timestamp number, text string)?
What format do you want to display it in Power Apps?

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No
11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

Keep the database value as a Date/DateTime field and only format it in the UI using Text(). This avoids issues with sorting, filtering, and calculations.

For example:

Text(ThisItem.OrderDate,"dd-mmm-yyyy")

is preferred over storing "05-Jun-2026" as text in the database.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @CU03051719-0,

Assuming you are referring to displaying it in a Date Picker, you can use the Format property of the control to display it in any valid format - example
"dd/mm/yyyy"

will display it in "normal" (non-USA) format 30/01/2026 (30 Jan)
"dddd, d mmmm yyyy"

will display Thursday, 30 January 2026
"ddd, d mmm yy"

will display Thu, 30 Jan 26

All user input, display and saving will work as normal

If you want to display the date in a Label (not a Date Picker), wrap everything above in Text(DateFieldName)
Text(ThisItem.YourDataFieldName, "dddd, d mmmm yyyy")

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

Riyaz_riz11 4,204 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

Please try this:

Text(ThisItem.CreatedDate, "dd/mm/yyyy") Result : 07/06/2026

Text(ThisItem.CreatedDate, "dd-mmm-yyyy") Result : 07-Jun-2026

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No