Optional DATE/TIME parameter...

[dBjason]

Well, thought I had it all down until this!

I have a date range parameter (well, actually 3) the user selects to filter report data. Naturally, the user probably won't know specific dates s/he needs in some (most) cases.

For other parameters, I mooched some code off this site for an "ALL" value (thanx synapsevampire). Works great.

Now how in the @#$! can I do the same for a date range parameter? Is the only way to use a far-off future date (2999) as a default and then code a similar IF statement???

Thanks in advance,
Jason

 

[synapsevampire]

That's a common means (although I use impossible older dates because my report should still be providing brilliant information in 2999), but it depends on the database/connectivity and the version of your software.

-k

 

[dBjason]

Eeek! Sorry, CR 9.2.2

 

[synapsevampire]

Example using a default of 1/1/1970:

(
if minimum({?MyParm}) <> cdate(1970,1,1) then
{table.date} in {?MyParm}
else
if minimum({?MyParm}) = cdate(1970,1,1) then
True
)

-k

 

[dBjason]

Thanks!