Colour code by expreesion

[#1]

Hi all ,

does the following code is correct? not working actually

if(Status='Sanctioned But Not Disbursed',$(Blue),

if((Today-Date1)>=0 and (Today-Date1)<=1,$(Pink),

if((Today-Date1)>=2 and (Today-Date1)<=3,$(Yellow),

if((Today-Date1)>=4 and (Today-Date1)<=5,$(Green),

if((Today-Date1)>=6 and (Today-Date1)<=14,$(Blue),

if((Today-Date1)>=15 and (Today-Date1)<=30,$(Blue),

if((Today-Date1)>=31,$(Beige))))))))

Any Advice

Regards

Charlie

[vinieme12]

create your Day buckets during data load, and then refer them in the Color expressions

example

Pick(Match(DayBucket,'0-1 Days','2-3 Days',.........),red(),green(),......)

[dsharmaqv]

use num function in your expression like below

If(num(Today())-num(Date1)>=1,Red(),Blue())