Date formula for a Specific Month Crystal 8.0 -> 1

[acr1]

Hi All
I have a DateTime Field in a front end program that has a oracle db backend..

I want to extract data for a date ..eg (June 2003) from the database using Crystal 8.5

I have tried the 'ToText'...but need to get all entries for a specified month.

Any help asap would be appreciated.
Thanks
Angus

 

[Madawc]

Try something like

{M1.Date} >= Date(2003, 06, 01)
and {M1.Date} <= Date(2003, 06, 30)

Call it @Junedate, and test for it in your selection

Madawc Williams (East Anglia)