I need the dates from the field week_ending for the past 8 weeks also I need the next 4 week dates and I have to have it under the same field name because I am using it with coldfusion charts. Can anyone help.
Some of my code:
SELECT shop, (Five_S_tbl.week_ending and Five_S_Tbl.week_ending + 7 and Five_S_Tbl.week_ending + 14) as End_week, five_s_score, last_audit_score
FROM Five_S_Tbl
where shop = '722'
and week_ending > (TO_DATE(sysdate) - 61)
order by week_ending
Some of my code:
SELECT shop, (Five_S_tbl.week_ending and Five_S_Tbl.week_ending + 7 and Five_S_Tbl.week_ending + 14) as End_week, five_s_score, last_audit_score
FROM Five_S_Tbl
where shop = '722'
and week_ending > (TO_DATE(sysdate) - 61)
order by week_ending