Subtracting Dates 1

[tseh]

Is there a way to subtract one date from the other in the select statemtent to get the difference in number of days?

 

[Cagliostro]

select (day(datecolumn1)-day(datecolumn2)) as daydifference, other_things from sometable John Fill

 

[tseh]

This returns the number of days...but how do I get the months in days as well? Example, 04/30/01 - 02/28/01 returns 2. How do I get it to return 61 days?

 

[foxdev]

Use the DateDiff function with the 'd' parameter. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org

 

[Cagliostro]

datediff(day, '04/30/2001','02/28/2001') John Fill