Seperating Date/Time Field

A

AdminD&R

How do I separate a Date/Time Field in a query, such that
I have two separate field(s) one Date and one Time?
 
A

Allen Browne

Type these expressions into two columns of your query design grid (Field
row):

DateBit: DateValue([YourFieldNameHere])
and
TimeBit: TimeValue([YourFieldNameHere])
 

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

Countdown macro - display settings 2
Dcount -Date Criteria - Won´t find it - 0
Formatting templates 7
Autofill Date in Word 15.33 for Mac 0
Creating Forms 0
MS Project Center-Autolink column fields 0
Copy previous record into form field 0
VBA - exporting serial letters to single documents 0

Top