How extract date part of date/time ?

V

Van T. Dinh

If you only want to show the date only in a Control, set the Format of the
Control to "Short Date" or "mm/dd/yyyy" or similar.

If actually want to extract the date value without the time component, use
the DateValue() function. Check Access VB Help on this function.
 

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
Formatting templates 7
Date and Time Picker 6.0 0
Autofill Date in Word 15.33 for Mac 0
Creating Forms 0
How to automate update on weekly reports spreadsheet 0
Project Status Date 1
date & Time 1

Top