Date format question (1 Viewer)

[arage]

Entering 6/26/01 in my form date field gives 10/01/62. The field has an input mask ## / ## ## and format of mm/dd/yy so how can I allow 6/26/01 to be entered as well as 06/26/01?

 

[jimbrooking]

Suggest you remove the input mask entirely. That way you can enter 6/26 and it will be interpreted as 06/26/01.

You might also change the Format property to something like "mm/dd/yyyy" to obtain a consistent display format, in this case, 06/26/2001.

Jim

 

[arage]

Jim, am I missing something when I said in my original post that the format property was mm/dd/yy? Because you said to use a format property of “mm/dd/yy” is there a difference? Thanks.

 

[Pat Hartman]

Jim suggested using 4 digit years rather than 2 digit years as you were. I concur. Despite Y2K having happened 1.5 years ago, you still need to be aware of the fact that ALL programs are making an assumption about the century when you just enter a 2 digit year. And although that is not normally a problem, I prefer to "see" the 4 digit year so I can be aware of what was assumed.