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

mondinelli I tried both your ways and only the first worked but I don't want that format... I prefer the format of the second way that doesn't work.

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?