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

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