topic Date Issue Windows Update? 5/10/10 in QlikView https://community.qlik.com/t5/QlikView/Date-Issue-Windows-Update-5-10-10/m-p/227641#M79745 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have had two clients who have both experienced YTD formula problems today.</P><P>The formula is usually something like:</P><P>Sum({$&lt;Month=&gt;} If(inyeartodate(GLDate,vMaxDate,0,7),TRANAMOUNT))</P><P></P><P>One is running 8.5, the other is running 9 SR2, and they cannot see the YTD columns (blank).</P><P></P><P>Any ideas what may have caused this (i am assuming it is outside of Qlikview at this point).</P><P></P><P></P><P></P></BODY></HTML> Tue, 05 Oct 2010 08:12:17 GMT 2010-10-05T08:12:17Z Date Issue Windows Update? 5/10/10 https://community.qlik.com/t5/QlikView/Date-Issue-Windows-Update-5-10-10/m-p/227641#M79745 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have had two clients who have both experienced YTD formula problems today.</P><P>The formula is usually something like:</P><P>Sum({$&lt;Month=&gt;} If(inyeartodate(GLDate,vMaxDate,0,7),TRANAMOUNT))</P><P></P><P>One is running 8.5, the other is running 9 SR2, and they cannot see the YTD columns (blank).</P><P></P><P>Any ideas what may have caused this (i am assuming it is outside of Qlikview at this point).</P><P></P><P></P><P></P></BODY></HTML> Tue, 05 Oct 2010 08:12:17 GMT https://community.qlik.com/t5/QlikView/Date-Issue-Windows-Update-5-10-10/m-p/227641#M79745 2010-10-05T08:12:17Z Date Issue Windows Update? 5/10/10 https://community.qlik.com/t5/QlikView/Date-Issue-Windows-Update-5-10-10/m-p/227642#M79746 <HTML><HEAD></HEAD><BODY><P>Hello Matt,</P><P>Probably obvious but have you checked taht in your 9SR2 document GLDate and vMaxDate are formatted alike?</P><P>Regards</P></BODY></HTML> Tue, 05 Oct 2010 08:17:53 GMT https://community.qlik.com/t5/QlikView/Date-Issue-Windows-Update-5-10-10/m-p/227642#M79746 Miguel_Angel_Baeyens 2010-10-05T08:17:53Z Date Issue Windows Update? 5/10/10 https://community.qlik.com/t5/QlikView/Date-Issue-Windows-Update-5-10-10/m-p/227643#M79747 <HTML><HEAD></HEAD><BODY><P>Upgrading one user from 8.5 to 9 SR3 resolved scenario #1.</P><P>That doesn't help us with identifying the root cause though.....</P></BODY></HTML> Tue, 05 Oct 2010 08:38:45 GMT https://community.qlik.com/t5/QlikView/Date-Issue-Windows-Update-5-10-10/m-p/227643#M79747 2010-10-05T08:38:45Z