Would like date year to be entered as 12 or 2012 to return 2012 always

[Draconius]

I have a date field that is a short date format, have Date() as default value, and the input mask as 99/99/9900;0;" " so theoretically I could enter "7/27/12" OR "7/27/2012" and both should come out as 7/27/2012, but if you enter 2 digits for the year, it won't allow. It MUST have all 4 digits of the year be typed in. I would like the ability to do both.



Any assistance on this?

[help_me_with_access]

use your own mask. then caste the string value as a date when you need it. that's always an option. why not that?

by the way, for numeric placeholders in acc, 9's are optionals and 0's are mandatories. if you did know that, try using "0099" instead of "9900" and see what the program tells you about your programming ignorance.

e.g. => if it doesn't yell at you, maybe you can use it!!

[help_me_with_access]

or hey, another thing you could do is just purposely truncate the date when you need it outputted in pre-formatted objects, like reports. obviously the function would always be: RIGHT(datevalue, 2).

[Draconius]

use your own mask. then caste the string value as a date when you need it. that's always an option. why not that?

by the way, for numeric placeholders in acc, 9's are optionals and 0's are mandatories. if you did know that, try using "0099" instead of "9900" and see what the program tells you about your programming ignorance.

e.g. => if it doesn't yell at you, maybe you can use it!!

0099 worked! Of course, I could probably go so far as make it all 9's to allow someone to just enter 7/27 and it return 7/27/2012.

THANKS!!!

[help_me_with_access]

sure thing. happiness achieve in this thread. wooohooo!