Tuesday, June 14, 2011

Date Conversion to DD/MM/YYYY JD Edwards Developer Tools

Date Conversion to DD/MM/YYYY JD Edwards without using Business Function :-
 
VA rpt_AlphaSpecData10_DT = concat(concat(concat(lpad(date_day([BC Date - Terminated (F060116) (DT)]),"0",2),'/'),concat(lpad(date_month([BC Date - Terminated (F060116) (DT)]),"0",2),'/')),date_year([BC Date - Terminated (F060116) (DT)]))
Convert String to Date

No comments: