color expression for date

[Anonymous]

I need expression for date please, like:

green color = 2 months or above

red color = expired

yellow color = 1 month or less

like the following:

Color Measures

[Frank_Hartmann]

can u provide sample qvw?

[Anonymous]

Hi Mr. Frank,

find the attached file please.

[vishsaggi]

May be this?

Attached.

[Anonymous]

vishsaggi‌ I can't open the file because I don't have a license, can you please copy & paste the expression here !

Best regards

[hemanthaanichet]

Go to expression tab

expand the +

background color

Apply the below expression

=IF([Contract Validity] >= Date(AddMonths(Today(),2), 'MM/DD/YYYY'), RGB(0,202,101), IF(Year([Contract Validity]) <Year(Today()), LightRed(), IF([Contract Validity] < Date(AddMonths(Today(),1), 'MM/DD/YYYY'), Yellow())))

[vishsaggi]

In your expression tab - Background Color, use below:

= IF(Year([Contract Validity]) < Year(Today()), LightRed(),

  IF([Contract Validity] >= Date(AddMonths(Today(),2), 'MM/DD/YYYY'), RGB(0,202,101),

  IF([Contract Validity] < Date(AddMonths(Today(),1), 'MM/DD/YYYY'), Yellow())))