Forum Discussion

mork's avatar
mork
Icon for Helper V rankHelper V
10 years ago

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...
Need Help
mork's avatar
mork
Icon for Helper V rankHelper V
10 years ago

It doesn't show an error, it just creates the column with the word error in every cell.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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.

 

 

  • mork's avatar
    mork
    Icon for Helper V rankHelper V
    10 years ago

    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