Prefix a three-digit year with a zero on tab out in a date field
Summary:
Unlike Oracle Fusion Cloud, where the date field is refreshed to 4 digit (prefixed 0) if you enter 3 digit year and tab out, VB is not converting the year to 4 digit by prefixing the 0. However, it does stores the value with 0 prefix to the underlying variable.
For example, user entered 10/12/234, it should convert into 10/12/0234. (year gets converted as expected for single digit, 2 digits and greater than 4 digits, but not 3 digits)
Is it possible with the converter to see if it achieves the desired result, or would it be necessary to write custom logic? Please advise..
Tagged:
0