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
52
Views
6
Comments

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

https://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=converters&demo=dateTimeConverter

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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