DoubleBass
Reputation: 1173
MS Access: How to strip time off a date field?
For example a value in a field might be
8/5/2010 11:18:22 AM
And I want to strip it down to
8/5/2010
It is a Date/Time field format
Upvotes: 5
Views: 21090
Answers (2)
user12295
Reputation: 29
Time is a decimal place so if you don't want time then update the field using:
round(number,NumDigitsAfterDecimal as long)
Upvotes: 0
Related Questions
- Time Formatting for MS Access Query
- Remove timestamp tag from a date
- Remove Date Ambiguity
- Removing Date from Date/Time field in Access
- Convert date time string to date
- SQL-only find time and not date in Access Date/Time field
- Change date format in Access
- How to convert a text field to a date/time field in Access 2010?
- MS Access - Using time values without Date values
- MS-access wrong date format when converting field from text to date/time