Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

MS Access: How to strip time off a date field?

Tags:

ms-access

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

like image 447
DoubleBass Avatar asked Mar 14 '13 20:03

DoubleBass

1 Answers

Solved the issue using DateValue()

like image 55
DoubleBass Avatar answered Oct 03 '22 23:10

DoubleBass
Sign in to Comment

Related questions

MS Access Can't Find Project or Library Error
How do you import json data from a url utilizing VBA?
Unrecognized database format accdb in visual studio
Concatenating Title and Name Strings in Access
How can I add a button to an Access report to export it to Excel / PDF?
ADODB connection to ACCDB file -- unrecognized database format error
SQL Server 2008: should I be using Windows auth or SQL Server auth?
Record count in Access table using VBA
CountIf formula within MS Access report
Closing a bound form without saving changes
postgres to MS Access
import tab-delimited txt into Access table using VBA
VB.Net Checking if DataSet has rows or not
SQL Distinct Count with Group By
Access 2013 VBA - Setting New Click Event for Controls
Create a List of Dates in Access Query
Export Objects in MSAccess Application to Text Objects, and Import Into A New MDB
Retrieve list of indexes in an Access database
Why is this very simple SQL query failing in MS Access?
Multi-level GROUP BY clause not allowed in subquery

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!