Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a contract table which includes the fields:-
[Contract Start Date]
[Contract Duration In Months]
[Contract Status]
I want to list the columns in a straight table and then add one more column
showing the date the contract should expire.
This is calculated as:- addmonths (Contract_Start_Date, Contract_Duration_in_Months)
as Contract_Expire_Date on the table load.
However…I would like the straight table to highlight the Contract_Expire_Date background
in red if the Contract_Expire_Date has passed current date ( i.e. Contract_Expire_Date < Today() ).
However I’m not sure how to do that.
There is the ‘Visual Cues’ tab with an ‘Upper’ and ‘Lower’ option but I’m not
clear how to code this as an expression that would work. Is there another way?
Guidance would be appreciated.
Click on + sign on your Contract_Expire_Date or any other expression you have used.
Write below in Background color expression
IF(AddMonths([Contract Start Date],[Contract Duration In Months]) <= Today(), RED())
Click on + sign on your Contract_Expire_Date or any other expression you have used.
Write below in Background color expression
IF(AddMonths([Contract Start Date],[Contract Duration In Months]) <= Today(), RED())
Yuop that did it.
Thanks.
So much to learn.....