Date (Year) showing as 0201 instead of 19XX

[Anonymous]

Hi there, 

I'm trying to create a Calendar Table, using the CALENDARAUTO function, but for some reason, the format in the year is a list of numbers starting on 0201 and going on beyond 3401, etc. This is happening only in the new crated calendar table, the others show the regular format "3/9/2022".

I tried with the formating options but without success.

Why is this happening and more important, how can I get back to a regular format (1986, 2001, etc) in the years?

THANKS in advance 🙂

[Whitewater100]

HI:

Looks like you can use:

  Year = FORMAT(Calendar[Date], "yyyy")

[Anonymous]

I tried but get the same odd format 0201...

[Whitewater100 · Accepted solution]

I would start over and use CALENDAR function. Clendar auto searches all your columns from all of your tables and creates a potentially massive calendar. It can pick up on peoples birhdates and such. I never use it. Try CALENDAR function. Here's an example for a calendar for 2021 -2022.

Go to Modeling > New Table.

DATES = CALENDAR(DATE(2021, 1, 1), DATE(2022,12,31))

You can select add new column to put in Year on this new table.

YEAR = YEAR(Dates[Date])

MONTH No. = MONTH(Dates[Date])

Month Name = FORMAT(Dates[Date],"mmm")

Week No. = WEEKNUM(Dates[Date])

etc.