Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date comparison IF statement

Hi there,

I have a table like the below. I'd like to say

IF [Due Date] is before TODAYS DATE then, colour the cell RED

I have the below so far:

IF([Target Date] ={'>$(=date(today(),'dd/mm/yyyy''))'} and [Action Status]='Open',LightGreen(),  yellow())

Can you help me get this right?

date.PNG

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be this?

IF([Target Date] =date(today(),'dd/MM/yyyy') and [Action Status]='Open',LightGreen(),  yellow())


Or, even


IF([Target Date] =today() and [Action Status]='Open',LightGreen(),  yellow())

View solution in original post

2 Replies
tresesco
MVP
MVP

May be this?

IF([Target Date] =date(today(),'dd/MM/yyyy') and [Action Status]='Open',LightGreen(),  yellow())


Or, even


IF([Target Date] =today() and [Action Status]='Open',LightGreen(),  yellow())

Chanty4u
MVP
MVP

mm takes as minitues so u can use 'MM'