Converting datetime to date

[triton]

I'm working with a linked table and the table has a timestamp field that is in a general format ex. 4/18/2007 7:00:34 PM

I need a way through a query that I can get the timestamp field to read in a short date format so I can link this table with another that is using the short date format with no time.

Any help would be much appreciated.

Thanks in advance

 

[VicRauch]

in the query grid, do this:

Field:      TimeStampField
Table:      YourTableName
Sort:
Show:
Criteria:   DateSerial(Year([DateReal]),Month([DateReal]),Day([DateReal]))

Change the field and table names I have used to your own table and field names. If the two date fields have the same name, then you will need the table name in front of the DateReal field.

 

[triton]

Thanks for the help