Forum Discussion

Rich_G10's avatar
Rich_G10
Copper Contributor
Sep 19, 2019
Solved

Lists Web Part - Dates

I have created a page and added the list web part to the page. One of my columns is date. However it produces the date in the American style - today is 09/19/2019 for September 19th. Is there a sett...
Lists
SharePoint Online
Sites
  • Norman Young's avatar
    Norman Young
    Sep 20, 2019

    Hi Rich_G10,

     

    I believe the "List" web part gets the date format from the List, which in turn gets it from the sites "Regional settings".

     

    Does your sites "Regional settings" match the date format you are trying to implement?

     

    I changed my test site from English (Canada) - "MM/DD/YYYY" to English (Australia) - "DD/MM/YYYY" and the List web part works as expected.

     

    I hope this helps.

     

    Norm

     

Norman Young's avatar
Norman Young
MVP
Sep 20, 2019

Hi Rich_G10,

 

I believe the "List" web part gets the date format from the List, which in turn gets it from the sites "Regional settings".

 

Does your sites "Regional settings" match the date format you are trying to implement?

 

I changed my test site from English (Canada) - "MM/DD/YYYY" to English (Australia) - "DD/MM/YYYY" and the List web part works as expected.

 

I hope this helps.

 

Norm

 

Rich_G10's avatar
Rich_G10
Copper Contributor
Sep 20, 2019

Norman YoungThank you!! That worked perfectly, Much appreciated.

Resources