Show Only Month from date

[Dimitris]

Hi all and merry X-mas (to come)
I wish to get a report from a query that gives me data shorted by date.

In the report i can Group by date BUT what i whant is to group BY MONTH.
for this i need to transform the date field into another that will show me Only the Month + Year (without date).

ideas?

Tks in advance
Dimitri.

 

[namliam]

Change your date to a month using the Month formula or the Format formula depending on what you exactly want.

Format (Yourdate, "YYYY-MM") probably.

 

[Dimitris]

Tks a lot namliam.

it was so easy that makes me feel like stupid

cheers/Dimitri