You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Prefix a three-digit year with a zero on tab out in a date field

Accepted answer


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..

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!