Forum Discussion
Date from month column
Hi everyone,
I have a month column (January, February and so on) and a year column (2019, 2020 and 2021). I want to get a date column from they both. I recall once I saw a video where I could do something like #date(2020,"January",1) and it returns 1/1/2020 as date.
I do not remember the code but I hope you get what I am trying to achieve.
Thanks!!!
You need to use this syntax - #date(2020,1,1)
Or you can add a column with this expression (assumes Year is number column).
= Date.From([Month] & Text.From([Year]))
Pat
1 Reply
You need to use this syntax - #date(2020,1,1)
Or you can add a column with this expression (assumes Year is number column).
= Date.From([Month] & Text.From([Year]))
Pat