Using Date to select records...

[Timmkatt]

Crystal Reports 10. I have two fields,
Reservation.insert.date and Scheduled.Ride.Date. I need my report to show only the scheduled rides booked 7 or more days ago. Sort of like "Show me all records where Scheduled.Ride.Date is greater than or = to 7 days older than Reservation.insert.date". Any way this can be accomplished in the select expert with a formula? I would rather not have the user need to use parameters to accomplish this if there is another way. Thanks.

 

[kenhamady]

You have to do this in the selection formula, not the select expert. The formula would be something like:

{Reservation.insert.date} - {Scheduled.Ride.Date} >= 7

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[BOjdh2n]

Or you can use:

datediff('d',{Reservation.insert.date} - {Scheduled.Ride.Date}) >= 7

 

[lbass]

BOjdh2n probably meant to write:

datediff('d',{Reservation.insert.date}, {Scheduled.Ride.Date}) >= 7

If you insert a SQL expression {%diff} like:

datediff('d',`Reservation`.`insert.date`, `Scheduled`.`Ride.Date`)

...and then use a record selection formula like:

{%diff} >= 7

...the record selection formula will pass to the SQL statement.

-LB

 

[BOjdh2n]

Thanks,

Good catch and recomendation for passing the SQL to the DB.