hi guys...

anyone help me with this...

I'm trying to get the number of day between a date and today, this must be pretty easy but I'm new in this....so will appreciate any help

thanks......

Hi,

Try to alter the following as per your need:

select
date(current) ,created, day(date(current) - created) ,
("1/1/2000" - created),
(date(current) - created)
from systables where tabid =99


Hope it helps you.

Nitin

hi nitin...

well let me tell that works perfectly !!! , I really thank you....

regards....