How many days out...

2002-10-01 Thread Chuck Payne
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

Re: How many days out...

2002-10-01 Thread Paul DuBois
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