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!

Forms 12c: Data format problem when reading data from Excel to Forms

Ahmed HaroonMar 31 2017 — edited Jun 5 2017

hi all,

I had an Excel file as shown below, in column C there is Date + Time and Cell type = Custom

When read data in Forms the column Hire Date shows it very differently as below

our NLS_DATE_FORMAT is set to 'DD-MON-YYYY HH:MI:SS', in Forms this column (Hire Date) is Char type and width = 100

please help, how we can show the data as shown in Excel file ? in Forms 10g there is no problem at all.

regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 3 2017

Added on Mar 31 2017

#forms, #moved-from-devops

6 comments

1,213 views