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
 
Back
Top