topic Re: find date is greater than or not without set analysis in QlikView

find date is greater than or not without set analysis

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

if(paymentDate >= date($(SelectDateFrom),'MM-DD-YYYY'), True, False)

PaymentDate=15-06-2017

SelctedDateFrom=01-06-2017

But output is showing false please suggest the correct syntax to get the exact output

Re: find date is greater than or not without set analysis

Sergey_Shuklin — Wed, 24 Oct 2018 11:07:57 GMT

Hello!

Is this format "MM-DD-YYYY" suitable for such values 15-06-2017?

Re: find date is greater than or not without set analysis

avkeep01 — Wed, 24 Oct 2018 11:09:02 GMT

Hi manoj217‌,

Try '$(SelectedDateFrom)' and SelectedDateFrom instead of $(SelectedDateFrom) of maybe even $(=SelectedDateFrom). That can give different results.

Maybe it is because PaymentDate is with or without the capital P. But that is just a guess based on the different ways you wrote paymentDate.

Re: find date is greater than or not without set analysis

avkeep01 — Wed, 24 Oct 2018 11:11:22 GMT

Also you use: SelectDateFrom and SelctedDateFrom in your post. Maybe that is also wrong in you application.

Re: find date is greater than or not without set analysis

sunny_talwar — Wed, 24 Oct 2018 11:12:29 GMT

Try this

If(paymentDate >= Date#($(SelectDateFrom), 'MM-DD-YYYY'), True, False)

Re: find date is greater than or not without set analysis

sunny_talwar — Wed, 24 Oct 2018 11:13:08 GMT

or this

If(paymentDate >= Date#('$(SelectDateFrom)', 'MM-DD-YYYY'), True, False)

Re: find date is greater than or not without set analysis

avkeep01 — Wed, 24 Oct 2018 11:15:28 GMT

Try this, in my case it worked.

=if(PaymentDate>= date('$(SelectedDateFrom)'), True(), False())

Re: find date is greater than or not without set analysis

andrei_delta — Wed, 24 Oct 2018 12:12:30 GMT

hi,

you should format the "SelectDateFrom" as 'DD-MM-YYYY'.

Re: find date is greater than or not without set analysis

manoj217 — Wed, 24 Oct 2018 12:45:36 GMT

Sorry i gave an example only.

consider

paymentdate =06-15-2017

selecteddatefrom=06-01-2017

Re: find date is greater than or not without set analysis

manoj217 — Wed, 24 Oct 2018 12:46:04 GMT

not working every time it is showing false only

Re: find date is greater than or not without set analysis

avkeep01 — Wed, 24 Oct 2018 12:52:41 GMT

Did you check if all the fields and have the correct names? So can you attach an example? I'll attach mine.

Re: find date is greater than or not without set analysis

manoj217 — Wed, 24 Oct 2018 13:28:27 GMT

if(date(06-15-2017,'MM-DD-YYYY')>= date($(06-01-2017),'MM-DD-YYYY'), True, False)

check like this willl get the same