unable to modified the date
Summarygetting 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
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 .