DatePart of a Timestamp

K

K

Good day.

I have a field in a Query called CREATION_TS that displays the following
information 1/7/2008 10:46:55 PM. What expression could I use to best extract
just the date from this field.

Thanks

Kyle.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot figure out DatePart function 3
Format DatePart 4
Access Building a IIF expression in Access 0
Insert Access Dbase Field into a specific cell 3
(AutoNumber) referenced in a default expression, no value? 13
Sort on Date 1
datepart returns erroneous week number? 2
Datepart Function 3

Top