how can i show the week number and corresponding dates using the tax year
i tried Week(date, 0) but that shows 1-1-2012 as week 0
Eg; qc_data.date holds the date a qc inspection took place.
if i want to show that the first full week in April this year (2 april 2012 - 8 april 2012) as week 1
ie
Week||Date Range||Equipment ID||Result
1||2 april 2012 - 8 april 2012|| EID:100||Pass
2||9 april 2012 - 15 april 2012||EID:100||Fail
Many thanks in advance
KeeF