Problem with if condition and comparison dates

[geogou1973]

Hello.

I have the following formula in the background color of a field dimension

=if(COMPANY_CODE='01',argb(150,255,128,0),

IF(COMPANY_CODE=02 and CREATION_DATE<=$(UDATE),argb(150,128,255,128),

if(COMPANY_CODE='02',argb(255,255,255,255),

if(COMPANY_CODE='03',argb(150,0,101,179),

if(COMPANY_CODE='04',argb(150,100,177,255))))))

unfortunately the the comparison of the date CREATION_DATE<=$(UDATE) does not work.

Any help ?

Thank you in advance.

[geogou1973]

i found that the CREATION_DATE<=$(UDATE) need  '  like CREATION_DATE<='$(UDATE)'

[vishsaggi]

What is the date format of your CREATION_DATE field and in your variable $(UDATE).

DId you try giving single quotes around your variable as you mentioned like '$(UDATE)' ?