[mso] Re: Access 2000 date routines ? Pre-written somewhere?

Robert,

You need the DateDiff function, which will give you exactly what you
need.

Ray

------------------------------------
GR Business Process Solutions
Ray Blake
Head of Software Design
ray@xxxxxxxxx
Braedon
Newell Road
Hemel Hempstead
Herts HP3 9PD
tel: 01442 396518
fax: 01442 389353
mobile: 07834 226601
www.grbps.com
------------------------------------

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Robert Carneal
Sent: 17 June 2006 00:50
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access 2000 date routines ? Pre-written somewhere?

It seems as though I saw a site with some "genealogy-related date
routines
for Access 2000" somewhere. Where you were allowed to view the code (in
some
cases, copy it if you wanted); and I think there was a small fee
involved.
($25.00/yr ??) If anyone knows what I am talking about, please let me
know.
I searched through my Archives and MSO Archives to no avail.

What I very much would like to do in Access is have two dates (one or
both
may be before 1900-01-01) and properly calculate the date to give a
seven-digit representation of age.
Example:
Date 1: 1855-01-15
Date 2: 1935-04-09

Age in years, months, days is 80yrs, 2mths, 25 days. Or, in YYYMMDD
format,
0800225. A YYYMMDD format allows for a max age of 9991230, 999yrs, 12
mths,
& 30 days. Does anyone recall this please?

Thank you.

Robert



*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: