Forum Discussion

etsik's avatar
etsik
Copper Contributor
Jun 05, 2020

SPO List - Date column wrong format

Hello all,

 

I have a huge issue and would like to request your immediate help.

We've released within my company an SPO Site with a List for data entry.

In a column there is Date entry (no time)

Formatting varies from user entries.

 

Can we somehow conditional format the column to display always the date formatted DD/MM/YYYY (regardless user's input) ?????

 

Lists
SharePoint Online
Sites
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Jun 05, 2020

    etsik go to Site Settings and over on the left in Regional Settings make sure your settings are set to your local timezone, e.g. London for dd/mm/yyyy.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

    • etsik's avatar
      etsik
      Copper Contributor
      Jun 05, 2020

      RobElliottthanks for your prompt reply.

       

      Root site settings were already set to English UK and calendar in Gregorian. (company based in GR)

       

      Issue still present.

       

      Any formulas in column validation wont do the job?

Resources