topic Re: Formula Today in QlikView https://community.qlik.com/t5/QlikView/Formula-Today/m-p/770890#M1298439 <HTML><HEAD></HEAD><BODY><P>Please post sample app / data.</P></BODY></HTML> Sat, 20 Dec 2014 22:47:41 GMT MarcoWedel 2014-12-20T22:47:41Z Formula Today https://community.qlik.com/t5/QlikView/Formula-Today/m-p/770889#M1298436 <HTML><HEAD></HEAD><BODY><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">( {&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">BMITODAYYEAR2</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"$(JaarTov)"</SPAN><SPAN style="font-size: 8pt;">},</SPAN><SPAN style="color: #800000; font-size: 8pt;">BMIDAYNR2</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"=Num(Month(Today())) &amp; Num(Day(Today()))"</SPAN><SPAN style="font-size: 8pt;">} &gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">BMITODAYBRUTO2</SPAN><SPAN style="font-size: 8pt;"> ) &gt;} BMITODAYBRUTO2 </SPAN><STRONG style=": ; color: #ff0000; font-size: 8pt;">)</STRONG><SPAN style="font-size: 8pt;"> </SPAN></P><P></P><P></P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P>I think, <SPAN style="color: #800000; font-size: 8pt;">BMIDAYNR2</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"=Num(Month(Today())) &amp; Num(Day(Today()))"</SPAN><SPAN style="font-size: 8pt;">}&nbsp; this part is wrong.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Who knows the correct answer, her should BMIDAYNR2 equal mto mdd (monthnumber, daynumber)</SPAN></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Formula-Today/m-p/770889#M1298436 2026-01-26T18:19:17Z Re: Formula Today https://community.qlik.com/t5/QlikView/Formula-Today/m-p/770890#M1298439 <HTML><HEAD></HEAD><BODY><P>Please post sample app / data.</P></BODY></HTML> Sat, 20 Dec 2014 22:47:41 GMT https://community.qlik.com/t5/QlikView/Formula-Today/m-p/770890#M1298439 MarcoWedel 2014-12-20T22:47:41Z