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 ',';
SELECT csv_data
FROM (
SELECT
MACRO_KEY || ',' ||
TIMEREF || ',' ||
MACRO || ',' ||
DESCRIPTION || ',' ||
OPERATOR || ',' ||
REASON || ',' ||
SITENUM || ',' ||
REPLICATED || ',' ||
WORKSTATION csv_data,
CASE
WHEN EXTRACT (WEEK FROM TIMEREF) = EXTRACT (WEEK FROM
CURRENT_DATE) THEN ‘Today’
ELSE 'Other'
END period
FROM MACROLOG
ORDER BY TIMEREF)
WHERE period = 'Today';
