IF function

[Anonymous]

Hi,

Can I get help transforming this logic into a syntax;

IF 'Current Date' minus 'Transaction Date' greater than 180 days and Balance(Fieldname) is greater than zero than '> 180',

IF 'Current Date' minus 'Transaction Date' greater than 90 days and Balance(Fieldname) is greater than zero than '> 90',

IF 'Current Date' minus 'Transaction Date' greater than 60 days and Balance(Fieldname) is greater than zero than '> 60',

IF 'Current Date' minus 'Transaction Date' greater than 30days and Balance(Fieldname) is greater than zero than '> 30'    AS AGEING;

[kumarnatarajan]

Hi,

See the below mentioned syntex. this very usefull for you.

if(Interval(Today()-DueDate,'DD')<=0,Dual('Not Due',0),

if(Interval(Today()-DueDate,'DD')<=30,Dual('1-30',30),

if(Interval(Today()-DueDate,'DD')<=60,Dual('31-60',60),

if(Interval(Today()-DueDate,'DD')<=90,Dual('61-90',90),

if(Interval(Today()-DueDate,'DD')<=120,Dual('91-120',120),

if(Interval(Today()-DueDate,'DD')<=150,Dual('121-180',180),

Dual('> 180',181)

)))))) as AGEING,

The use Dual() function for sorting orders