Date problem

[#1]

Hi All,

I am new to Qlikview so excuse me if this question is really simple.

I have used following function which seems to work quite well:

If([Revised Due Date]<=today()-61,[Line Debt],0)

I tried to replace today's date with the specific date or end of the month date but it doesn't give me correct results.

Could you please help??

[MK_QSL]

how you tried? Can you post the expression pls?

[#3]

I have tried:

If([Revised Due Date]<=30/11/2014-61,[Line Debt],0)

and all sort of combinations with monthend expreccion.

[kristoferahlin · Accepted solution]

The problem is most likely with the date format. You might want to try something like:

If([Revised Due Date]<= Date(Date#('30/11/2014', 'DD/MM/YYYY')-61, 'DD/MM/YYYY'),[Line Debt],0)

You might want to consider putting end of month in a variable, like vMonthEnd = MonthEnd(Today()). Then use that variable in your expression.

[#5]

Thank you very much for your help.

I've been trying to work it out myself for two days

It pays off to ask for help.