changing a datetime field to just a date field in an access table

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

Guest

I have a table in access that contains a datetime stamp. I REALLy don't want
to have to reimport so is there an easy way to change the field to a date
stamp...
 
DateValue(MyDateTimeField) will return only the date portion.

You can either create a query that applies that function, and use the query
wherever you would otherwise have used the table (just in case you change
your mind later...), or you can write an Update query that reassigns the
field the truncated value.
 

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

Excel Convert Datetime Stamp to HH and MM Worked 7
Date Stamp Only When *Field* Changes, not Whenever *Record* Change 4
Access 2007 - Entering of datetime values in double field 1
How to validate time format from a text field? 2
Insert date-time value using SQL? 2
Date stamp an entry in a memo field 2
date/time field converting UTC to default timezone 4
Remove Time from DateTime 4

Back
Top