Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert date into first of month

Shadow123May 2 2016 — edited May 3 2016

Oracle 10g forms

Hi All

I have a database item that's is called :trust_balances.balance_date, its type is date and its format mask is 'MON-YYYY'.

In this item user usually enter date something like MAY-2016 and oracle assume that this date =01-May-2016.

Now the problem is that if user enter date something like :trust_balances.balance_date=MAY16 then oracle assume this date format like 16-MAY-2016 but I what I want is that if user enter MAY16 then oracle automatically convert it with 01-May-2016, how come I do that ?. Please suggest

This post has been answered by Andreas Weiden on May 3 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 31 2016

Added on May 2 2016

#forms, #moved-from-devops

4 comments

740 views