Forum Discussion
Solved
date.weekofyear by field
I am trying to create a column that records the week number based on the date found in another column. Below is a screenshot of what i am trying to accomplish. The column that I have the date store...
As jgeddes mention, use Date.WeekOfYear([Date Counted]), if it doesnot solve your problem, use this one
Date.WeekOfYear(Date.From([Date Counted]))
1. Remove #date() and change it to Date WeekofYear([Date Counted])。
2. The Date.WeekofYear function returns a numerical value, not a date, so type date should not be used at the end of line 15. You can use type number or Int64.Type (if you want it to be an integer)
1. Remove #date() and change it to Date WeekofYear([Date Counted])。
2. The Date.WeekofYear function returns a numerical value, not a date, so type date should not be used at the end of line 15. You can use type number or Int64.Type (if you want it to be an integer)