Outputing Weeks Of Year And Comparing Date Ranges
Posted on 2005-05-01
Looking the best way to create a dynamic table to display the following, using COLDFUSION MX, with this question i am more concerned in working out the query for the date compares: -
Display Weeks Of Fiscal Year (April to March) as table header
Perform Query To Count Total Costs Of Items That Fall In Each Week
Week Starts On Monday and ends on Sunday ?, flexible with this...
eg.. Year 2005
Table Header (Week Numbers for 2005 Starting From April)
02nd April | 09th April | 16th April | 23rd April | 30th April |07th May etc...
Category1 2000 4500 etc..
Category2 3000 5000 etc..
Category3 4000 6000 etc..
Some type of count(*) but who do i compare with the 52 weeks in the specified FISCAL Year ??
ITEM Categorys TABLE
Any advice on how to accomplish this would be much appreciated