topic InMonthToDate() & Leap Year problem in QlikView https://community.qlik.com/t5/QlikView/InMonthToDate-Leap-Year-problem/m-p/446910#M166729 <HTML><HEAD></HEAD><BODY><P>Has anyone faced an issue with the InMonthToDate() function when comparing with a date a year ago when the prior year was a leap year.</P><P></P><P>Essentially what seems to be happening is that 2/29 of every year after the leap year gets skipped. here's my flag,</P><P></P><P><STRONG>If(InMonthToDate(MasterCalendarDate, AsOfDate, -12),1,null()) as FlagLastYrCurrMTD,</STRONG></P><P><STRONG>If(InMonth(MasterCalendarDate, AsOfDate, -12),1,null()) as FlagLastYrCurrMonth,</STRONG></P><P>&nbsp;&nbsp;&nbsp; </P><P>I am building an AsOfDate table that references other dates in reference to a date selected. So if the AsOf Month = February 2013, 02/29/2012 would be considered InMonthToDate as the entire month has passed, so both flags would be 1.</P><P></P><P>thoughts anyone?</P></BODY></HTML> Fri, 15 Mar 2013 19:12:50 GMT avastani 2013-03-15T19:12:50Z InMonthToDate() & Leap Year problem https://community.qlik.com/t5/QlikView/InMonthToDate-Leap-Year-problem/m-p/446910#M166729 <HTML><HEAD></HEAD><BODY><P>Has anyone faced an issue with the InMonthToDate() function when comparing with a date a year ago when the prior year was a leap year.</P><P></P><P>Essentially what seems to be happening is that 2/29 of every year after the leap year gets skipped. here's my flag,</P><P></P><P><STRONG>If(InMonthToDate(MasterCalendarDate, AsOfDate, -12),1,null()) as FlagLastYrCurrMTD,</STRONG></P><P><STRONG>If(InMonth(MasterCalendarDate, AsOfDate, -12),1,null()) as FlagLastYrCurrMonth,</STRONG></P><P>&nbsp;&nbsp;&nbsp; </P><P>I am building an AsOfDate table that references other dates in reference to a date selected. So if the AsOf Month = February 2013, 02/29/2012 would be considered InMonthToDate as the entire month has passed, so both flags would be 1.</P><P></P><P>thoughts anyone?</P></BODY></HTML> Fri, 15 Mar 2013 19:12:50 GMT https://community.qlik.com/t5/QlikView/InMonthToDate-Leap-Year-problem/m-p/446910#M166729 avastani 2013-03-15T19:12:50Z