[Date Index] [Thread Index] [Author Index]

Re: list of dates

• To: mathgroup at smc.vnet.net
• Subject: [mg88394] Re: list of dates
• From: Albert Retey <awnl at arcor.net>
• Date: Sat, 3 May 2008 06:20:39 -0400 (EDT)
• References: <fvegu1$5e9$1@smc.vnet.net>

Roger Nye wrote:
> Hi,
> I have a list of dates in the format YYYY-MM-DD and I want to convert them 
> to a decimal value, so 1963-01-01 goes to 63.0 and 1985-07-01 goes roughly 
> to 85.5.
> 
> Any suggestions on the best way to do this?

In version 6:

DateDifference["1900-01-01", "1963-01-01", "Year"][[1]]

DateDifference["1900-01-01", "1985-07-01", "Year"][[1]]

hth,

albert