How can I find the number of days between two date using sql query. I want to guery some records and determine from the currernt day and the creation date if it is 21 days old.

Hi

You need to use the DATEDIFF function, try this tutorila by Dennis:

www.dmxzone.com/showDetail.asp?TypeId=2&NewsId=4155#DATEDIFF

Digga

Sharing Knowledge Saves Valuable Time!!!