Token eof expected

[alihijazi]

Hello

I'm trying to create a Calendar using List.Date function

I got the list correctly and I converted the list to a table

Now I want to create custom columns to have the year, month, etc...

However I'm getting an error saying Token eof expected; what's wrong? please advise

[alexpancakes]

= Date.Year([Date]) is the correct formula.

So "Date.Year()" is the function and the "[Date]" is it's argument.

[SabineOussi]

Try

Date.Year([Date])

Date.Month([Date])

[MattAllington · Accepted solution]

=[Date].Year([Date]) is not a valid formula.

Try duplicating the date column 3 times.  Then for each new column, use the menu Transform\Date\Year etc