Differnt age

[#1]

hi all!

I have perhaps a smaller problem but I have tried a lot of different  formula and the didn´t work.

I want to have <30 days and new column 31-90 91-180 and bigger then 365.

my formula is.

(today () - DATUM >='91',

if (today () - DATUM <= '180',

IF(ENH='KG' , (DISP1*TJOCKLEK_2*SPEC_VIKT)* KOSTPRIS))

IF(ENH='M2' , (DISP1* KOSTPRIS)))

[#2]

I have mark , red in qlikview I get red underline.

//bengt

if(interval(today()-DATUM)<30,'below 30',

if (interval(today()-DATUM)>=31 and interval(today()-DATUM)<90,'31 To 90',

if( interval(today()-DATUM)>=91 and interval(today()-DATUM<180),'91To180','Above 180') as Flag

[#3]

just need to close all if statement  & nested if brackets...

if(interval(today()-DATUM,'d')<30,'below 30',

  if(interval(today()-DATUM,'d')>=31 and interval(today()-DATUM,'d')<90,'31 To 90'

if(interval(today()-DATUM,'d')>=91 and interval(today()-DATUM,'d')<180.'91To180',

   if(interval(today()-DATUM,'d')>=181 and interval(today()-DATUM,'d')<360,'181 To 360','Above 360')))) as Flag