Calculating Number of Days

[ebizleads]

I have a date that i need to return the number of days since today. For instance the date may be 2/20/06 and I need the query for return a value of 3....since today is 2/23/06.

Thanks!

EbizLeads

 

[lespaul]

Look into the DateDiff function


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[PHV]

Or simply this:
Date() - [Date field]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886