Forum Discussion
Group By month
Hello all, I have a table of my Resources work per week that I'm trying to group by month. How can I do that? Example table bellow. ResourceName Week# WeekSt...
Mmm it's strange. First of all, you have problems with the "WeekStartDate", which is the format of that column? Because in my example dataset I've no problems.
With the formula I've posted I get something like this : 1-2016
You can also try to create two separate custom column, one with Date.Month() and one with Date.Year() and then merge them together.
The formula you provided worked. I just hadn't noticed that post and I was replying to your previous one about the error I was recieving. The WeekStartDate is type date