Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
need help
i have date like this
my requirement is if currentdate is less than due date i need to show in back ground clor as red color
dimension of duedate which is wriiten script is
date(Date(Num#([Due Date]),'DD-MON-YYYY')) as DUEdate,
can anyoneplease help
goto tab Dimension and click on "+" on your Dimension Duedate
Then open Background Color and define Expression like
if (Duedate < today(), red()
you Need to make sure that Duedate and today have the same date Format, if not use date function to bring them in same Format