Selecting Records Greater Than Seven Days Old

[lhooker]

I tried the Crystal Reports forum, but no responses. Can anyone see what I'm doing wrong with the below statement in Crystal Reports 8.5. I'm
trying to select reecords that exceed 7 days based on a Crystal Reports parameter. The parameter has the format of 2/27/2006 (Discrete value). The 'LastRouteDate' has a format of 'datetime'. Thanks ! ! !


{?Select_Date} - DateValue({Applications.LastRouteDate}) > 7

 

[iangirven]

dates

I havent used crystal reports so am having a guess at this one.

It looks to me that you are aksing for the date the wrong way round. I believe in VB asking for a date older than 7 days from todays date would be
<Date() -7.

this should return records where the date is more than 7 days old.

I know this is not what your looking for but hopefully will help point you in the right direction.

regards

ian

 

[lhooker]

Ian,

Thanks ! ! ! I'll try this . . .