Unusual date format

J

JH

Hi,

I have a bunch of users that enter a lot of dates and want to do so in a
hurry. Their preferred method is to enter them using the numeric keypad as
"010203" meaning 1st January 2003.Now I could just accept this into a text
field but they then need to do some date manipulations so it has to end up
in a date field in a table. I have written a class module to do this, but it
has severe limitations as I have to put a dummy text field on the form and
then extract the date into a date field.

This is OK on a single form but is a right pain in the proverbial on
continuous forms.

DOes anyone have any useful suggestions (other than telling the user to use
slash.... ;-))

John
 
K

Ken Snell [MVP]

Maybe you tried this already, but put an invisible textbox on the form that
is bound to the date field. Use the AfterUpdate event of the text-date
textbox to run code that converts the text string into the desired date
format and write that date to the invisible textbox.

Am scratching my head over how 010203 equates to January 1, 2003?
 
V

Van T. Dinh

"Am scratching my head over how 010203 equates to January 1, 2003?"

That's why the O.P. wrote "*unusual* date ..."??? <g>

Did you know that "October" means the 8th month of the year? (and November
9th month, December 10th month)
 
T

Tonín

Did you tried a short date mask? Users will see the slashes, but they won't
need to input them.


Tonín
Spain
 
J

JH

Thanks, will give it a go.

Sorry about 010203 = 1 Jan 2003! Should be 1 Feb 2003 - put it down to a
user error....

John
 
Top