[AccessD] Dividing days into years and months

Hi Paul

I'm guessing here but it sounds like you're talking about the number of
years etc between two dates. If that's true then check out the DateDiff
function and DateAdd functions. What you could do then is calc the DateDiff
in years, use DateAdd to add that number of years back onto your first date
then get the DateDiff between the new date and the original last date in
Months, then repeat to get the remaining number of days.

If I've misinterpreted what you want I'm sorry. If I'm right but you need
more help let me/us know.


--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: [AccessD] Dividing days into years and months
Date: 28/07/04 07:55

>
> Dear Experts
>
> I can divide in Access the days from a date() into years with a simple
> /365, but is there a way to have months and days ... so I have years,
months
> and days, please?
>
> Cheers paul
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2