some CreatedDate in excel are showing wrongly as mm/dd/yyyy instead dd/mm/yyyy

(1) Share

Report

Posted on by johnjohnPter

1,875 Season of Giving Solutions 2025

I have this workflow to get items from sharepoint and build an excel sheet file and table:-

Inside "Select related Data 2' i am using this format for the created date `if(empty(item()?['Created']),'',formatDateTime(item()?['Created'],'dd-MM-yyyy'))`.

now when i get the excel sheet , i can see that some dates are showing correctly as dd/mm/yyyy for example 13 Febrauary 2025, while other are showing as mm/dd/yyyy.. so we have items created on 2 November 2025 (which is in the future).. as follow:-

my local setting on the PC following the UK format, and also the site regional setting .. and the date will be returned in the following format from the Get Item action:-

so why some excel rows have the date format wrongly? Thanks in advance for any help.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Chriddle 8,689 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Simply don't format the date 😉

Was this reply helpful? Yes No
johnjohnPter 1,875 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

@Chriddle will this fix the issue? and how? i need to format mainly to remove the time.

Was this reply helpful? Yes No
Suggested answer

Tomac 4,055 Moderator on at

Like (0)

Report
Copy link

Link copied!

@johnjohnPter When you select the Created column in Excel, is the format for these cells set to Short D

If so, it will use your Windows date format for display. My guess that the first 26 rows in your sheet are set to the correct format but not the entire column.

Was this reply helpful? Yes No
Verified answer

Chriddle 8,689 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Chriddle will this fix the issue? and how? i need to format mainly to remove the time.

The Excel connector expects either ISO 8106-formatted date strings or the American date format.
Therefore, the day and month in your Excel spreadsheet were swapped, and dates from the 13th onward were not recognized as dates and therefore remained unchanged but left-aligned in the Excel cell.

So if you really want to truncate the time, use formatDateTime(item()?['Created'],'yyyy-MM-dd') or use startOfDay(item()?['Created']) to set the time to 00:00.

1 people found this reply helpful.

Was this reply helpful? Yes No
johnjohnPter 1,875 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

@Chriddle seems formatDateTime(item()?['Created'],'yyyy-MM-dd') did the trick , thanks

Was this reply helpful? Yes No