SharePoint quick steps using wrong date format

Question

SharePoint quick steps using wrong date format

Anderson, Simon 5

Using SharePoint lists, have started using quick steps to update dates quickly. This has previously worked with no issues.

Today when trying to use it I received an "invalid date format" error in the cell. I have confirmed that the region locale setting is correct and when I input the date manually the format is dd/mm/yyyy. But the quick steps date format is set to mm/dd/yyyy and I can't find a way to change this to the correct format.

0 comments

1 answer

Your answer

Answer 1

Darren-Ng 9,885 Microsoft External Staff Moderator

Dear @Anderson, Simon,

Thank you for posting your question in the Microsoft Q&A forum.

Based on your description, your SharePoint list’s Quick steps/inline edit is parsing dates with the US format (mm/dd/yyyy) while your site and manual entry use dd/mm/yyyy.

Here are some suggestions you can try:

Confirm your personal language & region

Go to Microsoft 365 profile > Language and region.
Set Preferred language to one that uses dd/mm/yyyy (e.g., English (United Kingdom)) and set Region accordingly.
Sign out/in to refresh.

Check the site regional settings

SharePoint site > Settings (gear) > Site information > View all site settings > Regional settings.
Set Locale to English (United Kingdom) (or any dd/mm/yyyy locale) and verify Time zone.
If the site is associated with a hub, confirm the hub’s regional settings too.

Let me know if you get stuck in any steps or if we misunderstand your point, please correct us and provide more detail information so we could support you more effective

I hope information above helpful, if you have any other questions, please feel free to reach out.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

User's image

Darren-Ng 9,885 Reputation points Microsoft External Staff Moderator

2025-11-16T06:14:59.42+00:00

Dear @Anderson, Simon,

Just checking in to see if the above information was helpful. If you have any further updates on this issue, please feel free to post back. If you think my reply is helpful to you, please remember to mark it as an answer. Warm thanks.
Christian Gosselin 0 Reputation points

2026-03-25T17:19:35.37+00:00
Hello,

I’m experiencing the same issue with date formats in SharePoint Quick Steps.

My environment is fully set to French (Canada):

Browser language: French (Canada)

SharePoint site regional settings: French (Canada)

User profile regional settings: French (Canada)

With this configuration, dates across the site are consistently displayed and entered as YYYY-MM-DD.

However, when I use a Quick Step to update a date column, the value is set/displayed as DD/MM/YYYY, which causes a format mismatch.

It appears that Quick Steps are ignoring the site and user regional settings and instead using a different default format.

Is this expected behavior? If so, is there any way to force Quick Steps to respect the regional settings or use ISO format (YYYY-MM-DD)?

Thank you.
Darren-Ng 9,885 Reputation points Microsoft External Staff Moderator

2026-03-30T07:06:56.4+00:00

Dear @Christian Gosselin,

Since the original poster has not responded for quite some time, I kindly recommend creating a new, separate post for your issue and applying the correct tags. Opening a dedicated thread helps ensure that your question is clearly visible to the community and not overlooked within an older or inactive discussion.

Creating a new post also allows more community members, including those who specialize in your specific topic, to discover your question and provide faster assistance. In general, new threads receive higher visibility and engagement, which increases the chances of receiving helpful replies.

Thank you for your understanding

Share via

SharePoint quick steps using wrong date format

1 answer

Your answer