when i enter 01/01/46 in a DOB date field with input mask of: 99/99/00;0;_, it defaults to 01/01/2046
How do i revise to function properly?
Thanks,
John
when i enter 01/01/46 in a DOB date field with input mask of: 99/99/00;0;_, it defaults to 01/01/2046
How do i revise to function properly?
Thanks,
John
force a 4 digit year
99/99/9999
i'd remove the mask. The date may interpret correctly. I never use it.
I would, but i like not having to enter the full year. Any other solutions?
Just noticed that dates before 1950 default to 20xx and dates from 1950 forward are displayed appropriately.
Thanks,
John
that is the default basisJust noticed that dates before 1950 default to 20xx and dates from 1950 forward are displayed appropriately.
guess you could use the dateadd function - something like
dateadd("yyyy",year(mydate)<2050,mydate())
but not sure what you want to happen if mydate = 2010