Help I need to removing time stamp on a date field

[Alex Martinez]

Hello,

In my table called (DataImport) I have a field called "ReceivedDate" I get a
data dump from our AS400 system, which I export into the table. My problem
is besides getting the data I get the time stamp as well (3/9/2006 12:25:29
PM). This is giving me problems in my query with matching other date fields
that doesn't have a time stamp. I tired putting a mask on the
"ReceivedDate" field and I even format the field as short date, but I still
have the time stamp. How can I get rid of the current time stamp and how
can I prevent geting the time stamp, unfortunately IT does not want to be
bother changing from date/time stamp to just giving me the date only. I
recived the data thru a pass thru query. Can someone help me. Any tips
will be appreciated. Thank you in advance.

 

[Rick Brandt]

Hello,

In my table called (DataImport) I have a field called "ReceivedDate"
I get a data dump from our AS400 system, which I export into the
table. My problem is besides getting the data I get the time stamp
as well (3/9/2006 12:25:29 PM). This is giving me problems in my
query with matching other date fields that doesn't have a time stamp.
I tired putting a mask on the "ReceivedDate" field and I even format
the field as short date, but I still have the time stamp. How can I
get rid of the current time stamp and how can I prevent geting the
time stamp, unfortunately IT does not want to be bother changing from
date/time stamp to just giving me the date only. I recived the data
thru a pass thru query. Can someone help me. Any tips will be
appreciated. Thank you in advance.

In your Passthrough query wrap the Timestamp field in the Date() function. That
will strip the time component off.

SELECT SomeField, SomeOtherField, Date(YourTimeStampField), etc...