date.weekofyear by field

[chrismoncrief]

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.

[Omid_Motamedise · Accepted solution]

hi @chrismoncrief 

As @jgeddes mention, use Date.WeekOfYear([Date Counted]), if it doesnot solve your problem, use this one

Date.WeekOfYear(Date.From([Date Counted]))

[ZhangKun · Accepted solution]

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)

[Omid_Motamedise · Accepted solution]

hi @chrismoncrief 

As @jgeddes mention, use Date.WeekOfYear([Date Counted]), if it doesnot solve your problem, use this one

Date.WeekOfYear(Date.From([Date Counted]))

[jgeddes]

Does Date.WeekOfYear([Date Counted]) without the #date() wrapper fix your error?