date format

[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

 

[Guest]

if you want to store only the month and the year, then change the type from
date to text type

 

[Guest]

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