SOLVED
Home

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
Rich_G10
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
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

 

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

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

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

@Norman YoungThank again!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies