Data management cloud - data export by custom application

3047423

Hi Folks,

I am trying to export data out of EPBCS application into a file using data management cloud custom application.

My client need current period column to be populated in the output file as below,

Lets say i have run the data export for month Sep-19,

2019/09/30,Acc1,Dep1,Cus1,3435.57

am trying to play with $SQL in data loading mapping, it's giving syntax error,

thanks

venkat

JohnGoodwin

Try

TO_CHAR(LAST_DAY(SYSDATE),'YYYY/MM/DD')

JohnGoodwin

For the SQL, you can just put sysdate

Cheers

John

3047423

thanks john for solution,

am trying (LAST_DAY( SYSDATE )) to get last date of month format as a YYYY/MM/DD but it's giving format as a dd-mon-yyyy

I need last date of month format should be - YYYY/MM/DD ex: 2019/09/30

helpful if you suggest

JohnGoodwin

Try

TO_CHAR(LAST_DAY(SYSDATE),'YYYY/MM/DD')

3047423

Perfect john..!