[SOLVE]I need a SQL command, how to use date minus with system date know its last..

[wenight]

I need a SQL command, how to use date minus with system date know its last 3 day?

how to minus the date to know still have how many day left, but minimum but have 3day.... compare to system date...??

SELECT ProductNo, Gendate from ProductInfo 
WHERE Gendate - date() = 3
GROUP BY ProductNo, Gendate

[VBFnewcomer]

how to minus the date to know still have three more day compare to system date...??

Not clear what u are trying? Do you want to deduct 3 days from the system date?

[wenight]

I have already solve it...

[VBFnewcomer]

Good.
But take sometime to post your solution, it might help somebody.