Re: duration query: how to ?

[John Hicks]

Bedford Bob wrote:
> I'd like to retrieve the total amount of time the articles have been in the
> site from 2005-01-01 to 2005-01-31 and divide them by 365 (or 366 if leap
> year).
> 
> if an article has been online from 2004-10-01 to null (meaning the article
> hasn't been sold yet) then I may count 365 days
> 
> 

Did you mean from 2005-01-01 to 2005-12-31?

--J