Forum Discussion
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 stored in is circled in red, and I am trying to get the column "week" to return the week number for the "Date Counted" field.
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)
3 Replies
Does Date.WeekOfYear([Date Counted]) without the #date() wrapper fix your error?
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)
