Date Format sometimes incorrect

PeterKinnear

Hi

Firstly I am using English formatted dates DD/MM/YY (because the US format is wrong and terrible)

I have a sheet with dates in it. I have another sheet that points to these dates.

If my source dates are 33/12/2021 or similar they work correctly

If my source dates are for example 06/12/2021 then they appear incorrectly on the new sheet as 12/06/2021 even though the format is correct in the settings in everything

This is a major bug and needs immediate repair please, otherwise we cannot use this software.

Thanks

James Keuning

If my source dates are 33/12/2021 or similar they work correctly

Really?

Genevieve P.

https://community.smartsheet.com/discussion/90855/date-format-sometimes-incorrect

Hi @PeterKinnear

When you say that you're using English "formatted" dates, are you only using the in-sheet Date Formatting (see here), or have you set your account to have this Date structure (see here)?

I would suggest making sure that your account is set to have DD/MM/YY. Then, check to ensure that the owner of the second sheet also has this setting.

If this hasn't helped it would be useful to see screen captures, but please block out sensitive data. Thanks!

Genevieve