I want to autogenerate a calendar that goes from the first day of 2010 to today.
I have this:
date(date#(20091231,'YYYYMMDD')+recno(),'MM/DD/YY') as "Date"
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!!!