i want to query some tables and filter in a where for a specific day.
INSERT INTO Table_Temp(uebnahmdatum, erfnr, schltermart, termdatum, abtlg,
select uebnahmdatum, archiv.erfnr, schltermart, termdatum, archiv.abtlg,
where archiv.lfdspaufnr = esview.auftr_nr and esview.lst_datum > "06.02.2012" <- here i want to change day automatically to current day minus 14 days.
and esview.haus = " 1"
and esview.abtlg = " 2";
mister google isn't very helpful to this problem.
the best solution i could think of to get the value i want, is getting it from another table, in which i write this "day minus 14" value with the help of a little program(written in c# or something).
to avoid this, i posted here to get some help.
for the reason i'm german, my english sucks. so please do not mind my syntax! :-P