Autogenerate Calendar

[villafuerte]

Hi,

I want to autogenerate a calendar that goes from the first day of 2010 to today.

I have this:

LOAD

date(date#(20091231,'YYYYMMDD')+recno(),'MM/DD/YY') as "Date"

AUTOGENERATE today();

The problem is that I don't know how to stop creating dates, I only want from 1-Jan-2010 to today.

Hope you can help!!!

[rwunderlich]

AUTOGENERATE today() - MakeDate(2010, 1, 1) + 1

-Rob