Help with Crystal Report v 4.0

[kathymc]

Hello

I am trying to update an old version of Crystal Reports.

I need to set up a query that will give me a report of all
records where Status = Active and DateStarted >= sStartDateEntered
and DateStarted <= sEndDateEntered.

I have it started, but can't figured how to add the date range.
Can someone help me with this?


sSQL = "{" + TABLE_CLIENTS + "." + C_FIELD_STATUS + "}"
sSQL = sSQL + " = " + Chr(34) + STATUS_ACTIVE + Chr(34)


This is what I tried by hard-coding it and I got an error in formula:

{Client.Status} = "ACTIVE" AND {Clients.DateStarted} >= "01/01/2009" AND {Clients.DateStarted} <= "02/15/2009"

[Constance]

Well I don't know this software at all, but are you sure the date format is correct according to what it would expect ?