Month end date comparism not working

isciberras — Tue, 13 Mar 2018 09:52:56 GMT

Hi everyone,

I am facing the following issue: I created a field using the formula monthend(invoice,1) to get the month end of an invoice for the next month.

I now want to compare the month end invoice date to a payment date. To do so I created the following expression:

If(payment < monthend, 'fine','issue')

This works for most cases but for some reason it gives back around 4 rows where the if statement is saying that its fine however in reality around 200 days would have passed so it should have been marked as an issue.

Anyone know what I might be doing incorrectly?

Thanks,

Isaac

Re: Month end date comparism not working

YoussefBelloum — Tue, 13 Mar 2018 09:59:21 GMT

Hi,

you should add more info/details here. try to attach some rows from your table, or a sample QVW

topic Re: Month end date comparism not working in QlikView

Month end date comparism not working

Re: Month end date comparism not working