InMonthToDate and InQuarterToDate Bug

[#1]

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

[#2]

Hi Amalekshahi,

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

Kind Regards,

Footsie

[#3]

Hi,

I am using QV 10 SR3.

Thanks