isnull, max date

[sandeep0000]

i have a end_date field, i need to get all nulls and max end date,

i was told i need to do something like this

isnull(max(end_dt),getdate


but i get an error

im using sql server

 

[sandeep0000]

i dont think i explained it very good the first time

basically if the end_dt is null then i want it, if not i want the max (end_dt)

 

[SQLBI]

Hi,

I pressuming that you're having trouble with your SQL ode for a query you're olanning to use in a Reporting Services Report.

This will give you the value of end_dt if NOT Null, and the MAX(end_dt) if it IS Null.

ISNULL(end_dt, MAX(end_dt))

This will give you the value of end_dt if NOT Null or the current system date if it IS Null.

ISNULL(end_dt, GETDATE())

Apologies but both your posts are a little unclear.

Cheers,
Leigh

"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip" - Eminem