date control out date only in the update event

[Ali29J]

Hi All

does anyone know how to output only the date (not time) on the afterupdate of a microsoft date control?

THanks

Ali

 

[Pampers]

how about date() instead of now()

Pampers
Keeping it simple can be complicated

 

[Remou]

Which control are you using? It is generally possible to format date/time to show just date or time.

 

[Ali29J]

I m using the microsoft date and time picker control 6.0. found in toolbox

after update it enters the date chosen and enters it into a text box, at present its enterring date and time but i only need the date

THanks

Ali

 

[Remou]

Have you looked at the properties specific to the control? It should be possible to set the format to short date. I find that my version of Access defaults to short date, so I wonder if you have any code related to this control?

 

[Pampers]

Maybe it is better to use another dateandtime picker then the one on the toolbox, like:

http://www.lebans.com/monthcalendar.htm

Pampers
Keeping it simple can be complicated

 

[PHV]

Anyway, the Int() function strips out the time portion of a DateTime field.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ali29J]

pampers nice little tool thankyou much cleaner than MS version