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

Visit Redwood Community
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

unable to modified the date

Accepted answer
18
Views
6
Comments
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!