Active X control DTpicker 6

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

How do I get the date picker to return only the date
rather than the date and time? Thanks.
 
Steve,

To Access date/time data type is actually a number with decimals, the
integer part being the date and the decimal part being the time. So, to get
just the date part, all you need is the Int() function on the date! Assuming
your DTPicker control is called ActivexCtl1, use: Int(ActivexCtl1). This is
fine for using in code etc., but if you need to show / print, then maybe
you'll need something like Format(Int(ActivexCtl1), "dd/mm/yy") etc.

HTH,
Nikos
 
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

DTPicker Default Date 0
Macro to modify property of an object 6
DTPicker controls missing from userform 4
Problems with MS-DateTime-Picker 6.0 2
Date Picker Default? 1
DTpicker and Active X on my new laptop 2
Date Picker with Inputmask 3
Date & Time Picker Properties Question 19

Back
Top