Well I don't know this software at all, but are you sure the date format is correct according to what it would expect ?
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"
Last edited by kathymc; 11-16-2009 at 05:15 PM. Reason: update query
Well I don't know this software at all, but are you sure the date format is correct according to what it would expect ?