selecttion formula between two date ranges.......

[ragpark]

I am using SQL Database and Using CrystalQuery for the selection or records.
Selection formula for above thing if I give
"cdatetime({Query.scheduledStartDate}) in cdatetime(2001,03,01) to cdatetime(2001,03,31)"
While viewing records it is giving "Bad datetime format string".............

Please give me the solution

 

[AdrianLamas]

"cdatetime({Query.scheduledStartDate}) in cdatetime(2001,03,01) to cdatetime(2001,03,31)"

May be it's waiting for datetime and you are passing only date.

Regards,
Adrian