PDA

View Full Version : Sleeper: Date/Time picker control



Shellgrip
07-06-2005, 07:25 AM
Gonna push my luck for two quick solutions in one day : pray2:

As a modification to the code/app I posted earlier I've decided to stick the MS date/time picker on so that my monkey users don't have problems entering dates. It all works fine but I need it to produce a UK date format, i.e. dd/mm/yy(yy). I'm solving it at the moment by using a middleman variable and FormatDateTime to fill the text box but this seems like a ham-fisted approach. Is there some way to force the control itself to generate a different date format?

Jon

shades
07-06-2005, 07:42 AM
I wonder if BlueCactus has a solution (http://www.vbaexpress.com/forum/showthread.php?t=3854) (that is compatible for both Macs and Windows).

Shellgrip
07-07-2005, 03:42 AM
Maybe it's me but I can't see anything on that thread that applies to my situation. I'm using the Microsoft Calendar Control 9.0, not written code.

As it happens, the solution I'm already using is working fine and is only a couple of lines so - if it ain't broke, don't fix it!

Thanks for the reply anyway. :thumb

Jon