Grouping on a date field

[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

 

[Guest]

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]

Thanks for that

A

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

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