Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
HDL FF w/ string to date conversion "dd-mon-yy" to "YYYY/MM/DD" — Cloud Customer Connect
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
edited Oct 12, 2020 11:44PM in HCM Integrations 1 comment


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



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.


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