Forum Discussion

CJDK's avatar
CJDK
Helper II
5 years ago
Solved

Dates not translating

I am translating a report to Russian and the dates are persistently showing in English. I have set the report locale to Russian and changed the Date column type to Russian. I have created a n...
Need Help
  • CJDK's avatar
    CJDK
    5 years ago

    A new column is needed in this situation, because the MonthYear column is a text column.

    1. Create a new month column - example below.
    2. Create a Year column from the date column in your dataset.
    3. Merge the new month column and the Year column.

    Example of new month column (Russian):

    RussianMonth = SWITCH(MONTH([Date]),1, "Янв", 2, "Фев", 3, "Мар", 4, "Апр", 5, "Май", 6, "Июн", 7, "Июл", 8, "Авг", 9, "Сен", 10, "Окт", 11, "Ноя", 12, "Дек", "Unknown month number" )

    With thanks to discussion in Change month name language.

CJDK's avatar
CJDK
Helper II
5 years ago

A new column is needed in this situation, because the MonthYear column is a text column.

  1. Create a new month column - example below.
  2. Create a Year column from the date column in your dataset.
  3. Merge the new month column and the Year column.

Example of new month column (Russian):

RussianMonth = SWITCH(MONTH([Date]),1, "Янв", 2, "Фев", 3, "Мар", 4, "Апр", 5, "Май", 6, "Июн", 7, "Июл", 8, "Авг", 9, "Сен", 10, "Окт", 11, "Ноя", 12, "Дек", "Unknown month number" )

With thanks to discussion in Change month name language.