Date-Time to Just a regular old Date

[BradB]

I have a table with dates in it. I DON'T want date-time. I just want the date. I 'm using the Short Date format. I'm linking and access table with a proprietary database that doesn't use date-time. I can't link the tables because access has date-time, and the other database has just Date.

Is there a way to change Date-Time to a regular Date. I'm linking tables with another database that doesn't accept Date-time?

 

[mikey69]

Rememnber that time is the decimal poart of a date/time variable, so you can strip off the time by using the int function. You can also deal with this by using the clng operator.