unable to modified the date — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

unable to modified the date

edited Jul 6, 2019 1:42PM in Integration 6 comments

Summary

getting date from flat file MM/DD/YYYY and need to change in yyyy/mm/dd FBDI date format but after format-dateTime function getting blank value

Content

Step to reproduce the issue - 

1- flat file where date coming i.g  12/03/2018   (MM/DD/YYYY)

after read operation while doing mapping(write map) with oracle FBDI format its getting error 

-need to change in FBDI format (YYYY/MM/DD)

- Already checked  xp20:format-dateTime(Date,'[Y0001]/[M01]/[D01]')    but its got bank value or error .

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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