topic Re: Date comparison IF statement in QlikView

Date comparison IF statement

Wed, 17 Feb 2016 11:59:18 GMT

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?

tresB — Wed, 17 Feb 2016 12:55:10 GMT

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 — Thu, 18 Feb 2016 09:02:53 GMT

mm takes as minitues so u can use 'MM'