|Subject||Help with Firebird date ranges.|
I am a complete noobie in regards Firebird, :-( and I have 1 system with that has Firebird installed.
I need to be able to report on the last 7 days data from the date a report is run.
Currently i have managed to cobble together (from a script, i have found) a script that will run and give me the current 'weeks' data. Sadly this only starts from the Monday of the week. However, as stated, I need the data to be the previous 7 days.
Is anyone able to advise where i am going wrong, and possibly offer up a solution?
Many thanks in advance.
The script i have is:
OUTPUT 'Macrologs.csv' DELIMITER ',';
MACRO_KEY || ',' ||
TIMEREF || ',' ||
MACRO || ',' ||
DESCRIPTION || ',' ||
OPERATOR || ',' ||
REASON || ',' ||
SITENUM || ',' ||
REPLICATED || ',' ||
WHEN EXTRACT (WEEK FROM TIMEREF) = EXTRACT (WEEK FROM CURRENT_DATE) THEN ‘Today’
ORDER BY TIMEREF)
WHERE period = 'Today';