Converting Date/Time to Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

need to know how to change a table that has Date and Time to just Date, when
i append to another table

for example, 8/30/2005 01:10:03am --> 8/30/2005
 
See help on DateValue()

In the field row of your Append query, you will have something like this:
DateValue([MyDateField])
 
You must log in or register to reply here.

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

Windows 7 I need to convert date to text 3
Which is the best MBOX Converter Tool different formats conversion? 5
Problem formatting dates from CSV file 2
Combining Date/Time 3
Excel Dragging countif formula with changing criteria 3
Period End Dates Table ... How to Link? 3
Converting Date & Time between time zones 7
Date Formula Needed 1

Back
Top