S
Steve
How do I get the date picker to return only the date
rather than the date and time? Thanks.
rather than the date and time? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Nikos Yannacopoulos
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
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