topic Autogenerate Calendar in QlikView https://community.qlik.com/t5/QlikView/Autogenerate-Calendar/m-p/244536#M1206151 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to autogenerate a calendar that goes from the first day of 2010 to today.</P><P></P><P>I have this:</P><P></P><P style="padding-left: 30px;">LOAD</P><P style="padding-left: 30px;">date(date#(20091231,'YYYYMMDD')+recno(),'MM/DD/YY') as "Date"</P><P style="padding-left: 30px;">AUTOGENERATE today();</P><BR /><BR /> <P></P><P>The problem is that I don't know how to stop creating dates, I only want from 1-Jan-2010 to today.</P><P></P><P></P><P>Hope you can help!!!</P></BODY></HTML> Wed, 24 Feb 2010 18:51:56 GMT villafuerte 2010-02-24T18:51:56Z Autogenerate Calendar https://community.qlik.com/t5/QlikView/Autogenerate-Calendar/m-p/244536#M1206151 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to autogenerate a calendar that goes from the first day of 2010 to today.</P><P></P><P>I have this:</P><P></P><P style="padding-left: 30px;">LOAD</P><P style="padding-left: 30px;">date(date#(20091231,'YYYYMMDD')+recno(),'MM/DD/YY') as "Date"</P><P style="padding-left: 30px;">AUTOGENERATE today();</P><BR /><BR /> <P></P><P>The problem is that I don't know how to stop creating dates, I only want from 1-Jan-2010 to today.</P><P></P><P></P><P>Hope you can help!!!</P></BODY></HTML> Wed, 24 Feb 2010 18:51:56 GMT https://community.qlik.com/t5/QlikView/Autogenerate-Calendar/m-p/244536#M1206151 villafuerte 2010-02-24T18:51:56Z Autogenerate Calendar https://community.qlik.com/t5/QlikView/Autogenerate-Calendar/m-p/244537#M1206152 <HTML><HEAD></HEAD><BODY><P>AUTOGENERATE today() - MakeDate(2010, 1, 1) + 1</P><P>-Rob</P></BODY></HTML> Wed, 24 Feb 2010 20:52:20 GMT https://community.qlik.com/t5/QlikView/Autogenerate-Calendar/m-p/244537#M1206152 rwunderlich 2010-02-24T20:52:20Z