[mso] Re: Custom Date difference
- From: "Ray Blake" <ray@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 20 Jul 2004 17:57:04 +0100
I assume Robert is using Excel, since most of his recent questions have
been about Excel. Given this, don't look in the Excel help file, nor in
the functions list, because both places omit this function. But I
promise you it's there. I have a web page which exmplains how to use it
here:
http://www.grbps.com/raq5.htm
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
www.grbps.com
------------------------------------
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of James LaBorde
Sent: 20 July 2004 16:17
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Custom Date difference :VSMail mx4
Robert,
I don't know which application you are using, but if it is either Access
or Excel and the only thing entered for the date is mm/yyyy, the first
is automatically assumed as the rest of the date. (You can check this by
temporarily changing the date format of the field. Just use the
DateDiff function and you should get a relatively close result.
James
-----Original Message-----
From: Robert Carneal [mailto:carnealre@xxxxxxxxxxxx]
Sent: Monday, July 19, 2004 10:18 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Custom Date difference :VSMail mx4
Does anyone know how to date the difference between two +similar+ dates?
I.e., in the format m/d/YYYY, I can obtain the difference between two
dates.
What if the entire date is not known?
Suppose the date of birth is given has 3/1905 (March, 1905), and the
death given as 10/1999 (Oct 1999)? I would like to get the difference.
Is there a way to obtain the difference, or should I make a "fictitious"
day (say the 15th) and change that to 3/15/1905 and 10/15/1999 and then
obtain the difference? Or is there an easier way to get the difference
with only Year and Month is known?
Avoid VBA please, I am not familiar with it.
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
*************************************************************
Other related posts:
