Building date range selection

[jazzercise]

I know this is probably easy - but we are having difficulties

I have a report that is date driven. I want to prompt the user for the begin and end date to filter the contents of the report. I want the user to enter 07012003 and this date is used to compare against a date/time stamp field in the database.

Any help is appreciated.

 

[bcaslow]

There are a fwe ways to accomplish this. What I usually do is create two global string variables: gBeginDate, gEndDate.

Override the ObtainSelectStatement (BEFORE the call to Super::ObtainSelectStatament() ) and do something like:

WhereClause = WhereClause & " And db.datecolumn between '" & Format(gBeginDate, "mm/dd/yyyy&quot & "' and '" & Format(gEndDate, "mm/dd/yyyy&quot & "'"

Don't forget to check to make sure there is a where clause (the above assumes there is and starts with " And..." as well as formatting to your database.



Bill