[mso] Re: Custom Date difference :VSMail mx4
- From: "Robert Carneal" <carnealre@xxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 20 Jul 2004 11:59:26 -0500
I am using Excel. Wow, the fact that it will work mm/yyyy was +not+
mentioned in anything I have. Thank you.
Robert
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of James LaBorde
Sent: Tuesday, July 20, 2004 10:17 AM
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
*************************************************************
*************************************************************
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:
