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
Convert String to Date
No comments:
Post a Comment