topic Creating a date from 3 variables? in QlikView https://community.qlik.com/t5/QlikView/Creating-a-date-from-3-variables/m-p/169811#M40475 <HTML><HEAD></HEAD><BODY><P>This feels like it should be so easy, but it just wont seem to give me the right results.</P><P>Basically,I have 3 variables.</P><P>vThisYear = max(year)</P><P>vThisMonth = max(month)</P><P>vThisDay = max(day)</P><P>why cant I go MakeDate($(vThisYear), $(vThisMonth), $(vThisDay)) ?</P></BODY></HTML> Fri, 05 Mar 2010 12:22:53 GMT richnorris 2010-03-05T12:22:53Z Creating a date from 3 variables? https://community.qlik.com/t5/QlikView/Creating-a-date-from-3-variables/m-p/169811#M40475 <HTML><HEAD></HEAD><BODY><P>This feels like it should be so easy, but it just wont seem to give me the right results.</P><P>Basically,I have 3 variables.</P><P>vThisYear = max(year)</P><P>vThisMonth = max(month)</P><P>vThisDay = max(day)</P><P>why cant I go MakeDate($(vThisYear), $(vThisMonth), $(vThisDay)) ?</P></BODY></HTML> Fri, 05 Mar 2010 12:22:53 GMT https://community.qlik.com/t5/QlikView/Creating-a-date-from-3-variables/m-p/169811#M40475 richnorris 2010-03-05T12:22:53Z Creating a date from 3 variables? https://community.qlik.com/t5/QlikView/Creating-a-date-from-3-variables/m-p/169812#M40476 <HTML><HEAD></HEAD><BODY><P>Ok, sussed it, its because I have 4 years selected, and february. last year was a leap year, but this is not, so my max day in feb is 29, which is invalid for 2010. Pretty lucky I spotted that corner case!</P></BODY></HTML> Fri, 05 Mar 2010 12:30:50 GMT https://community.qlik.com/t5/QlikView/Creating-a-date-from-3-variables/m-p/169812#M40476 richnorris 2010-03-05T12:30:50Z