Sep 19 2019 07:48 AM
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 setting I can change it to the non-American style - 19/09/2019?
Thanks
Sep 20 2019 06:12 AM
SolutionHi @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
Sep 20 2019 06:19 AM
@Norman YoungThank you!! That worked perfectly, Much appreciated.
Sep 20 2019 06:26 AM
@Norman YoungI do have one more question. It seems that we can not use the same date twice in the "List" web part. Is that right? It will not let us save an item to the list if has the same date as an existing item on the list. I must be doing something wrong!
Sep 20 2019 06:31 AM - edited Sep 20 2019 06:39 AM
@Rich_G10 check the list column definition and ensure that "Enforce unique values" is set to no.
Sep 20 2019 06:12 AM
SolutionHi @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