topic Bug or not? InMonthToDate function in QlikView https://community.qlik.com/t5/QlikView/Bug-or-not-InMonthToDate-function/m-p/151259#M29152 <HTML><HEAD></HEAD><BODY><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">= inmonthtodate ( '2006-04-25', '2006-05-30', -1 )</PRE><BR /><BR /> <P>returns -1 (true), which is to be expected.</P><P>But</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">= inmonthtodate ( '2006-04-25', '2006-05-31', -1 )</PRE><BR /><BR /> <P>returns 0.</P><P>May has 31 days. and April has 30. Same behavior is manifested when using any two months which follow one another and in which one has one day more then the other.</P><P>I'm using InMonthToDate function in a dashboard chart which compares this months sales to the previous months. When today's date becomes 31. graph is empty because quantity is always multiplied by 0.</P></BODY></HTML> Thu, 06 Aug 2009 20:12:45 GMT 2009-08-06T20:12:45Z Bug or not? InMonthToDate function https://community.qlik.com/t5/QlikView/Bug-or-not-InMonthToDate-function/m-p/151259#M29152 <HTML><HEAD></HEAD><BODY><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">= inmonthtodate ( '2006-04-25', '2006-05-30', -1 )</PRE><BR /><BR /> <P>returns -1 (true), which is to be expected.</P><P>But</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">= inmonthtodate ( '2006-04-25', '2006-05-31', -1 )</PRE><BR /><BR /> <P>returns 0.</P><P>May has 31 days. and April has 30. Same behavior is manifested when using any two months which follow one another and in which one has one day more then the other.</P><P>I'm using InMonthToDate function in a dashboard chart which compares this months sales to the previous months. When today's date becomes 31. graph is empty because quantity is always multiplied by 0.</P></BODY></HTML> Thu, 06 Aug 2009 20:12:45 GMT https://community.qlik.com/t5/QlikView/Bug-or-not-InMonthToDate-function/m-p/151259#M29152 2009-08-06T20:12:45Z Bug or not? InMonthToDate function https://community.qlik.com/t5/QlikView/Bug-or-not-InMonthToDate-function/m-p/151260#M29153 <HTML><HEAD></HEAD><BODY><P>That's a thing I would definitely send to support!</P><P>The helpfile does not really state how Qlikview behaves in this case:</P><P>= inmonthtodate ( '2006-04-25', '2006-04-31',0) return 0 as well; maybe because the 31 does not exist in April..</P></BODY></HTML> Thu, 06 Aug 2009 20:28:38 GMT https://community.qlik.com/t5/QlikView/Bug-or-not-InMonthToDate-function/m-p/151260#M29153 2009-08-06T20:28:38Z