access97: date string

[JMCN]

Can anyone give me some direction on how to return values without the "/"
since access imports the "7/1/2003" with the "/".

in my query i tried:

date: (DatePart("mmddyyy",[Field2]))

but i received an error message in the field "#Error" when i go to view it.

eventually i want to export it to a text file but when i do export it,
it still formatted as "7/1/2003" instead of "07012003".

any help would be appreciated.
thanks- jung

[Phil Stanton]

DateAsString: Format([InDate],"dd") & Format([InDate],"mm") &
Format([InDate],"yyyy")
Assumes that your InputDate is a date and that you are British (Your input
date is 7th January not 1st July). Whoops!!!, you are French. Which way
round are your dates?
Phil
"JMCN" <pi******@yahoo.fr> wrote in message
news:27**************************@posting.google.c om...

Can anyone give me some direction on how to return values without the "/"
since access imports the "7/1/2003" with the "/".

in my query i tried:

date: (DatePart("mmddyyy",[Field2]))

but i received an error message in the field "#Error" when i go to view it.
eventually i want to export it to a text file but when i do export it,
it still formatted as "7/1/2003" instead of "07012003".

any help would be appreciated.
thanks- jung

[Rich P]

In the query name field (design view of the query) write this:

Dtefld:Format(Datefld, "mmddyyyy")

that will convert "07/01/2003" to "07012003" using the VBA Format
function. This is also in the Access Help files under Format. If you
say Format(datefld, "mm-dd-yyyy") this will return "07-01-2003" (without
the quotations - I add those for emphasis).

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[JMCN]

Rich P <rp*****@aol.com> wrote in message news:<3f***********************@news.frii.net>...

In the query name field (design view of the query) write this:

Dtefld:Format(Datefld, "mmddyyyy")

that will convert "07/01/2003" to "07012003" using the VBA Format
function. This is also in the Access Help files under Format. If you
say Format(datefld, "mm-dd-yyyy") this will return "07-01-2003" (without
the quotations - I add those for emphasis).

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

thank you both!

phil - on my database, it is international with the dates. for
instance, the french format is exactly to the british but the "usa"
format is "mm-dd-yyyy".

cheers! jung