This is my query:
SELECT date, dat_exec, value, name FROM fn_view
where date <= '2006-01-01' and date_exec=(select max(date_exec) from
fn_view v
where v.name=fn_view.name)order by name
This is the fn_view
SELECT date, date_exec, name
FROM f_view
WHERE (Date = (SELECT MAX(date) FROM f_view v
WHERE v.name = fu_view.name AND name IN (SELECTname FROM
listname_view)))
My problem:
I would like to have the most up to date results for a period. but I do
not have anything displayed when I set up the period for 2006-01-01...I
have just the most up to date until now. I would like to have the most
up to date until 2006-01-01 for each ticket.