[mso] Re: Date Limitations for Excell vs. Access ?
- From: "Glenda Wells" <gwells@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 10 May 2005 14:10:14 -0400
I can't help with your specific question Robert but check out this site
for a LOT of information on working with dates/times in Excel.=20
http://www.cpearson.com/excel/datetime.htm#TOC
=20
-----Original Message-----
From: Robert Carneal [mailto:carnealre@xxxxxxxxxxxx]=20
Sent: Tuesday, May 10, 2005 01:08 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Date Limitations for Excell vs. Access ?
Hello. I am aware that in Excel's valid dates "begin" in 1900, which is
the reason for "adjustment" in date before performing an age
calculation, an estimate of birth date, or an estimate of the death date
calculations. Does the same hold true for Access 2000? The adjustment
was to add 2000 to the year and base calculations on that.
I am asking because the book I am learning Access from (Not Microsoft,
one of those "Teach yourself ___" books.) The book says Access will work
for any date from January 1, 1600 to the year 2199. I have only about 18
people born prior to 1600, so what would be the best solution for dates
with them?
I attended a one day Access class, in which we were handed materials the
instructor said he got from Microsoft, but this said Access could only
work with dates from 1932 to 2499. (If this is true, is there a
recommended work-around? I have 1,000s of dates before 1932.)
So I have three different sources, and three different date limitations.
Can someone correct this for me please so I can work with dates from
1543 to the present in Access?
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, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail).
//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
*************************************************************
*************************************************************
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, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//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
*************************************************************
Other related posts:
