Find Min & max Date and show Null

[#1]

Hi All,

I need the expression for a new field.

if event date is min show only the forecast date which is >event date

if event date is max show only the forecast date which is <event date. and make other dates as Null

Thankyou

Vam

[terezagr]

Try this:

if (min(event_date)>event_date, forecast_date,

     if(max(event_date)<event_date,forecast_date, '0'))

Regards,

T.

[#3]

No Tereza its not working..