How extract date part of date/time ?

  • Thread starter Thread starter David
  • Start date Start date
D

David

How extract date part of date/time to just show the date
on a form?
 
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.
 
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

Error -2147352567 (80020009), Access 2007 0
Convert a number to a date time via unbound feilds 2
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Passing value of a form control in the Row Source to a Chart 3
Delimit dates - how? 1
date & Time 1
Find the last file in a folder 2
display number of records on form from date range 0

Back
Top