List:General Discussion« Previous MessageNext Message »
From:John Hicks Date:May 18 2006 3:12pm
Subject:Re: duration query: how to ?
View as plain text  
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
Thread
duration query: how to ?Bedford Bob18 May
  • Re: duration query: how to ?Barry18 May
  • Re: duration query: how to ?Peter Brawley18 May
  • Re: duration query: how to ?John Hicks18 May