[mso] Re: Access Function - DatePart :VSMail mx2
- From: "Glenda Wells" <gwells@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 22 Sep 2003 16:08:55 -0400
I'm sure James. I removed all fields except the offender. Apparently one
cannot use "mm" or "dd" but must use "m" or "d" as needed to avoid the
invalid procedure call. The leading 0 thing is a killer as I need that
for my export. I can get my data appended but without the proper
format, it's useless. I was hoping to avoid exporting to excel then
formatting to get the leading 0 then exporting to .csv...sigh.=20
Thanks for taking a look. /g
-----Original Message-----
From: James LaBorde [mailto:jlaborde@xxxxxxxxx]=20
Sent: Monday, September 22, 2003 3:56 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access Function - DatePart :VSMail mx2
Glenda,
I've done this before myself. I have found that you have to use it
using the append rather than in a maketable query for it to work
properly. I've never seen the Invalid procedure call, I just end up
losing leading zero if I use a maketable query. If you are doing it in
code, you shouldn't be having the problem at all. I wish I could be of
more help, but I have no experience with the error as you are seeing it.
Are you doing any other fun stuff with your data? Are you positive that
this is the field with the problem?
James
-----Original Message-----
From: Glenda Wells [mailto:gwells@xxxxxxxxxxx]
Sent: Monday, September 22, 2003 12:07 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access Function - DatePart :VSMail mx2
Hi All.
I'm trying to use DatePart in Access 2002
I wrote this:
Birth Date: (DatePart("mm",[DOB]) & DatePart("dd",[DOB]) &
DatePart("yyyy",[DOB]))
and am getting an Invalid Procedure Call error.
The purpose is to export data to a predefined text-only layout where the
date format is: mmddyyyy
example: today's date, 9/22/2003 is supposed to export like this:
09222003
Any thoughts appreciated. /g
*************************************************************
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=20
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=20
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:
