I'm not sure quite what you're asking. When I make calendars, I'm just tying dates in to other "formats" of the date. For a calendar in that sense, something like this (untested):
[Fiscal Calendar]: LOAD date(date#(20061231,'YYYYMMDD')+recno(),'MM/DD/YY') as "Date" AUTOGENERATE today()-date#(20061231,'YYYYMMDD') ; LEFT JOIN ([Fiscal Calendar]) LOAD "Date" ,date(monthstart(Date),'MMM YY') as "Month" ,date(yearstart(Date),'YYYY') as "Calendar Year" ,date(yearstart(Date,0,4),'YYYY') as "Fiscal Year" RESIDENT [Fiscal Calendar]) ;
Thanks for your assistance. This code worked great. It created calendar up to current date. One more question- How would create calendar days greater than current date.
KarenSmith wrote:Thanks for your assistance. This code worked great. It created calendar up to current date. One more question- How would create calendar days greater than current date.
Just change this part of the code:
AUTOGENERATE today()-date#(20061231,'YYYYMMDD')
The AUTOGENERATE just generates a certain number of occurrences. Here, I calculate the number of occurrences such that it will generate everything between January 1, 2007 and today(). If you want a calendar through the end of the current year, for instance, you could do this:
