We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

HDL FF w/ string to date conversion "dd-mon-yy" to "YYYY/MM/DD"

Received Response
16
Views
1
Comments
edited Oct 12, 2020 11:44PM in HCM Integrations 1 comment

Summary

HDL FF w/ string to date conversion "dd-mon-yy" to "YYYY/MM/DD" causes fatal error on Generate Loader task of Load Data from File

Content

Hello:

As i attempt to convert "25-Apr-19" to write 'YYYY/MM/DD' to my UDT.Value I keep running into compile or run-time Generate Loader (Load Data from File) ends w/ Critical Error (no log file)

See 'POSITION8' and 'l_bencode_effective_date' in attached FF.   

Not sure if THIS LINE 168

 l_Bencode_Effective_Date = TO_CHAR(TO_DATE(POSITION8,'DD-MON-YY'),'YYYY/MM/DD')

OR from LINE 292-294 is the issue BELOW is causing fatal error

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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