Getting Rid of Time in Date Format When Exporting

[Nighthawk]

When I export the date from my Access 2002 inventory
database, the time is included, which I don't want. I've
read the Microsoft knowledge base article 291245 and
tried coding my query to solve the problem, but I must be
doing something wrong.

Here's my basic query:

SELECT tblFBNBooks.ID, tblFBNBooks.Title,
tblFBNBooks.Author, tblFBNBooks.PublishYear,
tblFBNBooks.Edition, tblFBNBooks.Printing,
tblFBNBooks.Inscription, tblFBNBooks.Binding,
tblFBNBooks.SourceCode, tblFBNBooks.AskingPrice,
tblFBNBooks.[Category#], tblFBNBooks.Print,
tblFBNBooks.DateEntered, tblFBNBooks.ABEDate
FROM tblFBNBooks
WHERE (((tblFBNBooks.Print)=1));

I'd like to get the time, which is printing in Word as
12:00 AM, out of there on both date fields (DateEntered
and ABEDate).

Here's the sample workaround Microsoft gives:

Query: ExportDates
------------------------------------------------
Type: Select Query

Field: Birthday2: Format([Birthday], "mm/dd/yy")

Could someone please explain exactly how to change the
coding in my query to make it exclue the time data?

 

[Ken Snell]

SELECT tblFBNBooks.ID, tblFBNBooks.Title,
tblFBNBooks.Author, tblFBNBooks.PublishYear,
tblFBNBooks.Edition, tblFBNBooks.Printing,
tblFBNBooks.Inscription, tblFBNBooks.Binding,
tblFBNBooks.SourceCode, tblFBNBooks.AskingPrice,
tblFBNBooks.[Category#], tblFBNBooks.Print,
Format(tblFBNBooks.DateEntered, "mm/dd/yyyy"),
Format(tblFBNBooks.ABEDate, "mm/dd/yyyy")
FROM tblFBNBooks
WHERE (((tblFBNBooks.Print)=1));

 

[Pam at Fly-by-Night Books]

Thanks. For some reason, I thought I'd tried the date
format and it didn't work. It works now, so I must have
been doing something wrong. Now I just need to fix the
problem with exporting prices. I'll post that problem
separately.

-----Original Message-----
SELECT tblFBNBooks.ID, tblFBNBooks.Title,
tblFBNBooks.Author, tblFBNBooks.PublishYear,
tblFBNBooks.Edition, tblFBNBooks.Printing,
tblFBNBooks.Inscription, tblFBNBooks.Binding,
tblFBNBooks.SourceCode, tblFBNBooks.AskingPrice,
tblFBNBooks.[Category#], tblFBNBooks.Print,
Format(tblFBNBooks.DateEntered, "mm/dd/yyyy"),
Format(tblFBNBooks.ABEDate, "mm/dd/yyyy")
FROM tblFBNBooks
WHERE (((tblFBNBooks.Print)=1));



--
Ken Snell
<MS ACCESS MVP>

When I export the date from my Access 2002 inventory
database, the time is included, which I don't want. I've
read the Microsoft knowledge base article 291245 and
tried coding my query to solve the problem, but I must be
doing something wrong.

Here's my basic query:

SELECT tblFBNBooks.ID, tblFBNBooks.Title,
tblFBNBooks.Author, tblFBNBooks.PublishYear,
tblFBNBooks.Edition, tblFBNBooks.Printing,
tblFBNBooks.Inscription, tblFBNBooks.Binding,
tblFBNBooks.SourceCode, tblFBNBooks.AskingPrice,
tblFBNBooks.[Category#], tblFBNBooks.Print,
tblFBNBooks.DateEntered, tblFBNBooks.ABEDate
FROM tblFBNBooks
WHERE (((tblFBNBooks.Print)=1));

I'd like to get the time, which is printing in Word as
12:00 AM, out of there on both date fields (DateEntered
and ABEDate).

Here's the sample workaround Microsoft gives:

Query: ExportDates
------------------------------------------------
Type: Select Query

Field: Birthday2: Format([Birthday], "mm/dd/yy")

Could someone please explain exactly how to change the
coding in my query to make it exclue the time data?

.