Date Format sometimes incorrect

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

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.