Date column automatically formats to US date when manually inputted

%3CLINGO-SUB%20id%3D%22lingo-sub-2426071%22%20slang%3D%22en-US%22%3EDate%20column%20automatically%20formats%20to%20US%20date%20when%20manually%20inputted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2426071%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20of%20our%20lists%20has%20dates%20that%20act%20as%20triggers%20for%20automated%20emails%2C%20so%20it's%20important%20that%20they%20are%20formatted%20correctly.%20All%20manually%20inputted%20date%20auto%20format%20to%20the%20American%20date%20format%2C%20so%2001%2F02%20appears%20as%20January%20second%2C%20not%20Feb%20first.%20I've%20changed%20the%20regional%20settings%20on%20the%20site%2C%20and%20on%20the%20tenant%20in%20general%20and%20am%20still%20having%20this%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20at%20all%20is%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2426071%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi guys, 

 

One of our lists has dates that act as triggers for automated emails, so it's important that they are formatted correctly. All manually inputted date auto format to the American date format, so 01/02 appears as January second, not Feb first. I've changed the regional settings on the site, and on the tenant in general and am still having this issue.

 

Any help at all is welcome

0 Replies