Link to home
Start Free TrialLog in
Avatar of robhas
robhas

asked on

Mask Edit Control & Date

I have a field in an Access database set as a date and with a mask as date mm/dd/yy. On my app I have a masked edit control set to retrieve this field the mask property is set to 99/99/00;0; and the format to mm/dd/yy.  When I run my app it will display 11/24/_8 if the year is set to 98 in the database. If I turn the 98 to 68 it displays fine in the control.  When debugging booth the mask and the database field say 11/24/98. What could be the problem? Thanks.
Tried to remove mask from database but still get the same result.
Avatar of Inteqam
Inteqam

try to remove the mask from the database.

Avatar of robhas

ASKER

Removed the mask from the field in the database but it still happens.
Avatar of robhas

ASKER

Edited text of question
can you provide me with the code ,
to Hanzala@rocketmail.com

Try Setting The Input Mask To 99/99/99;0;_
Avatar of robhas

ASKER

Not the solution, still working at it.

 for date
set the format ddddd
and mask is ##/##/##
Now try it.

Avatar of robhas

ASKER

Does not work.
Try  ##/##/## ##:##
Avatar of robhas

ASKER

This answer does not work either.
ASKER CERTIFIED SOLUTION
Avatar of bear454
bear454

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of robhas

ASKER

It gave me very close to what I needed.