condition in script

[zied_ahmed1]

I have this table :

Table:

Load [Sales Forcast],

date

from table

I want to add a field named Sales_forcast_valid with this condition :

if (today()< date) Sales_forcast_valid  = [Sales Forcast]

else

Sales_forcast_valid  =0

Thanks for help

[m_woolf]

if(today()<date, [Sales Forcast],0) as Sales_forcast_valid,