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
Anonymous's avatar
Anonymous
Not applicable
10 years ago

mork try this:

 

   Number.ToText(Date.Month([WeekStartDate])) & "-" & Number.ToText(Date.Year([WeekStartDate]))

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

Anonymous That worked but can I change it to date type?