Hi,
I am having problems get how many days out an invoice is from mysql. I have
try this.
SELECT NOW()-summitted_date FROM table;
But it not working as usually. So please guys a little help.
So If an invoice was summitted on 9-26-02 then I should be able to see that
5 days.
Chuck Payne
Magi
At 15:41 -0400 10/1/02, Chuck Payne wrote:
Hi,
I am having problems get how many days out an invoice is from mysql. I have
try this.
SELECT NOW()-summitted_date FROM table;
But it not working as usually. So please guys a little help.
What do you mean not working as usually? A query written