Grouping on a date field

A

Alexey

Hi i have a date field and I want to count the number of records for each
month/year ( eg March 2007). i cant seem to get the format of the date
field right just to select the month year./ COuld someone help please

tks

A
 
A

Adrian Jones

Try:

MonthYear: format([yourDateField],"mmmm yyyy")

You might want to add a couple of hidden fields for Year([yourDateField])
and Month([yourDateField]) to sort the groups sensibly.

Adrian
 
A

Alexey

Thanks for that

A

Adrian Jones said:
Try:

MonthYear: format([yourDateField],"mmmm yyyy")

You might want to add a couple of hidden fields for Year([yourDateField])
and Month([yourDateField]) to sort the groups sensibly.

Adrian

Alexey said:
Hi i have a date field and I want to count the number of records for each
month/year ( eg March 2007). i cant seem to get the format of the date
field right just to select the month year./ COuld someone help please

tks

A
Click to expand...
Click to expand...
 
Top