topic InMonthToDate and InQuarterToDate Bug in QlikView

InMonthToDate and InQuarterToDate Bug

Wed, 27 Jul 2011 20:33:11 GMT

Hi There,

if (inmonthtodate( '5/31/2009', '6/30/2009', -1, 7), 'Yes','No') Returns No but if (inmonthtodate( '5/30/2009', '6/30/2009', -1, 7), 'Yes','No') returns Yes. There is something wrong with day 31. I have the same problem with InQuarterToDate function. It returns March 31 as not in Last Quarter but March 30 returns in last quarter!

Does anybody know a workaround to fix the problem?

Thanks

InMonthToDate and InQuarterToDate Bug

Thu, 28 Jul 2011 07:32:11 GMT

Hi Amalekshahi,

What version of Qlikview are you using as I am getting "No" for both expressions in Qikview 9 SR6.

Kind Regards,

Footsie

InMonthToDate and InQuarterToDate Bug

Thu, 28 Jul 2011 12:21:09 GMT

Hi,

I am using QV 10 SR3.

Thanks