SOLVED

Lists Web Part - Dates

%3CLINGO-SUB%20id%3D%22lingo-sub-863364%22%20slang%3D%22en-US%22%3ELists%20Web%20Part%20-%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863364%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%3EI%20have%20created%20a%20page%20and%20added%20the%20list%20web%20part%20to%20the%20page.%3CBR%20%2F%3EOne%20of%20my%20columns%20is%20date.%20However%20it%20produces%20the%20date%20in%20the%20American%20style%20-%20today%20is%2009%2F19%2F2019%20for%20September%2019th.%20Is%20there%20a%20setting%20I%20can%20change%20it%20to%20the%20non-American%20style%20-%2019%2F09%2F2019%3F%3CBR%20%2F%3EThanks%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-863364%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-867251%22%20slang%3D%22en-US%22%3ERe%3A%20Lists%20Web%20Part%20-%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-867251%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F407908%22%20target%3D%22_blank%22%3E%40Rich_G10%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20the%20%22List%22%20web%20part%20gets%20the%20date%20format%20from%20the%20List%2C%20which%20in%20turn%20gets%20it%20from%20the%20sites%20%22Regional%20settings%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20your%20sites%20%22Regional%20settings%22%20match%20the%20date%20format%20you%20are%20trying%20to%20implement%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20changed%20my%20test%20site%20from%20English%20(Canada)%20-%20%22MM%2FDD%2FYYYY%22%20to%20English%20(Australia)%20-%20%22DD%2FMM%2FYYYY%22%20and%20the%20List%20web%20part%20works%20as%20expected.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20839px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132774i44CA037D83162388%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-867257%22%20slang%3D%22en-US%22%3ERe%3A%20Lists%20Web%20Part%20-%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-867257%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3EThank%20you!!%20That%20worked%20perfectly%2C%20Much%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-867261%22%20slang%3D%22en-US%22%3ERe%3A%20Lists%20Web%20Part%20-%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-867261%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3EI%20do%20have%20one%20more%20question.%20It%20seems%20that%20we%20can%20not%20use%20the%20same%20date%20twice%20in%20the%26nbsp%3B%3CSPAN%3E%22List%22%20web%20part%3C%2FSPAN%3E.%20Is%20that%20right%3F%20It%20will%20not%20let%20us%20save%20an%20item%20to%20the%20list%20if%20has%20the%20same%20date%20as%20an%20existing%20item%20on%20the%20list.%20I%20must%20be%20doing%20something%20wrong!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-867279%22%20slang%3D%22en-US%22%3ERe%3A%20Lists%20Web%20Part%20-%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-867279%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3EThank%20again!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-867271%22%20slang%3D%22en-US%22%3ERe%3A%20Lists%20Web%20Part%20-%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-867271%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F407908%22%20target%3D%22_blank%22%3E%40Rich_G10%3C%2FA%3E%26nbsp%3Bcheck%20the%20list%20column%20definition%20and%20ensure%20that%20%22%3CSPAN%3EEnforce%20unique%20values%22%20is%20set%20to%26nbsp%3B%3CSTRONG%3Eno.%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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

5 Replies
Highlighted
Best Response confirmed by Rich_G10 (Occasional Contributor)
Solution

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.

Capture.PNG

 

I hope this helps.

 

Norm

 

Highlighted

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

Highlighted

@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!

Highlighted

@Rich_G10 check the list column definition and ensure that "Enforce unique values" is set to no.

Highlighted

@Norman YoungThank again!