first of month from the date field

[karnd]

Hi,

I have the date field which has populated from current to previous 10 years
and the date field format is like 2005-10-01 00:00:00.000

but i have to query the first of every month out of those values.

any ideas should be appreciated.

Thanks a lot,

 

[Madawc]

Try Date(Year({your.date}), Month({your.date}), 1)

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10