[AccessD] Dividing days into years and months

Scott Marcus marcus at tsstech.com
Wed Jul 28 06:15:39 CDT 2004


You said you already have days and years(Years is (days/365)). That leaves months and weeks. Months should be (days/365)*12. Weeks should be (days/365)*52.

Scott Marcus
TSS Technologies, Inc.
marcus at tsstech.com
(513) 772-7000

 -----Original Message-----
From: 	accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]  On Behalf Of Paul Rodgers
Sent:	Wednesday, July 28, 2004 3:52 AM
To:	'Access Developers discussion and problem solving'
Subject:	[AccessD] Dividing days into years and months

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







More information about the AccessD mailing list