Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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 .

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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