SSRS : Get min and max dates by default if the field is null

[Compufreak]

Hi all



please can you guys assist me...

I am trying to get the min and max dates should the start date and end date fields be null.

can anyone assist me with this ....

I did it before in access , I am now trying it in SSRS and well its killing me .

Thanks again guys

[June7]

What is SSRS and why do you post a question about it in an Access forum?

[Dal Jeanis]

Not sure what you mean by Min and Max Dates. If you mean the Minimum and Maximum dates that happen in the data, you can just use a far past and far future date in an IIF or NZ statement and let the data worry about itself.

WHERE TheDate >= NZ(MyStartDate,#01/01/1900#) 
AND  TheDate <= NZ(MyEndDate,#12/31/2199#)

[June7]

Nz might not work in SSRS (whatever that is). I think it is an Access function. I have known it to fail in Excel VBA code. I tried to have Excel link to Access query that used Nz and it bombed. Had to change the query. If Nz fails try the IIf:


WHERE TheDate BETWEEN IIf(IsNull([MyStartDate]),#01/01/1900#,[MyStartDate]) AND IIf(IsNull([MyEndDate]),#12/31/2199#,[MyEndDate])