date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi

i have a text box bound to a date/time field. i want user to input month and
year only in mm/yy format. at the mment i have text box format set to mm/yy
and input mask set to 09/99;0;_ but doesn't seem to work. eg. after entering
07/07 (meaning july 2007) it changes to 07/05 and when you click on text box
it shows 07/07/05.

any help please
 
if you want to store only the month and the year, then change the type from
date to text type
 
Another option will be, change the input to mm/yyyy, in the table it will
tranformed to 01/mm/yyyy
If the year will be 4 digits, it wont be mistaken for a month
 
Back
Top