date range help 1

[Bennie47250]

Crystal 7.0
MS SQL Database

Would like to have a formula or selection criteria to do the following.

Let’s say something is scheduled to ship on 7/25/13. I would like the record to show up on the report in 7/20, 7/21, 7/22, 7/23, 7/24 and finally 7/25. When the report runs on 7/26, the record no longer appears. The report will run every day of the week

Thanks
Bennie

 

[fisheromacse]

without knowing more about your report/data this is just a guess.

i would start with selection criteria something like:

{table.shipdate} < currentdate

 

[pmax9999]

Or perhaps:

{Table.ShipDate} in [CurrentDate to (CurrentDate + 5)]

Cheers
Pete

 

[Bennie47250]

pmax9999,

That is the solution I came up with too. Was hoping to find another more efficent way to do this.

Thanks
Bennie

 

[AndyMc]

That looks darn efficient to me!

 

[pmax9999]

Bennie47250

What is it that you believe is inefficient about this code (when used in the Record Selection)?

 

[Bennie47250]

Maybe inefficient is not the correct word I was looking for, how about something "slicker".

When I first looked at this I thought maybe I could use something like <= current date -5 or similar and since I could not get that to work figured I was just not smart enought to figure it out.

Regards

 

[BettyJ]

Not sure if this will help, but anyway
{Table.ShipDate} in [dateadd("d",-5,CurrentDate) to CurrentDate]