[AccessD] Date Diff Help It cant be this hard

On 9 Jan 2006 at 18:24, Gustav Brock wrote:

> Hi Arthur
> 
> I love the word "reliably" ...
> Try this:
> 
> ? Int(DateDiff("d", #1/9/1955#, Date())/365.26)
> ? Int(DateDiff("d", #1/9/1956#, Date())/365.26)
> 
> It would be nice but there is no simple and foolproof way.

Can you come up with an example that breaks the code I posted ealier?

Datediff("yyyy",dateborn,datenow) + _
(DatePart("y", datenow) < DatePart("y",dateborn))

-- 
Stuart