using a date value in a text column changes sometimes from German to US format

Joachim Mund

Hi all,

I have a date column and I am using the locale for germany.

The date column shows e.g.: 09.08.22

I use this in a text column like: ="some text " + date@row@rowanelizabeth

The result is sometimes "some text 09.08.22" and sometimes "some text 08/09/22"

What should I do, that always the german date format is used in the text column?

Thanks, Joachim

Find more posts tagged with

Formulas

Accepted answers

All comments

Julio S.

Hi @Joachim Mund,

I've been able to reproduce what you report and, although you can change the Date Column formatting to align with one suitable for all sheet users with different locale settings (Apply Standardized Date Formats in Your Sheet), the Text Column in your sheet with the formula you specify will always adjust for everyone to align with the locale settings of the last user who edited the values in that column.

There aren't any alternatives that I can offer to overcome this behavior, when you have a moment, please let our Product team know about your feedback by filling in this form, here. Thank you!

Julio

Edward Sheaf

I have this problem also and aside from breaking the date down to text values "dd" "mm" YYYY" in helper columns and then reassembling them as text I cannot guarantee the outcome, and doing this you lose any date functions because your column is a text not date column.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.