Getting Rid of Time in Date Format When Exporting

  • Thread starter Thread starter Nighthawk
  • Start date Start date
N

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?
 
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));
 
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?
Click to expand...


.
Click to expand...
 
Back
Top