khenyu
Member
i want convert the Julian Date into Normal Date.
the field name is (GLDGJ and GLDKJ)
select a.GLKCO as Company,a.GLMCU as BusinessUnit,a.GLOBJ as ObjectAccount,a.GLSUB as Subdiary,a.GLDGJ as GLDate, a.GLEXA as Explain1,a.GLEXR as Explain2, a.GLAA as ActualAmount,a.GLDOC as DocNo,a.GLJELN as JurnalLine,a.GLDKJ as Check_date, a.GLDCT as Doc_type,a.GLAN8 as AddressNum,b.WWMLNM + b.WWMLN1 as name from PRODDTA2.F0911,PRODDTA2.F0111 where GLCO in ('00700','00710') and GLOBJ='XXXX' and GLDGJ >=113001 and a.GLAN8=b.WWMLNM;
Can someone advise me?
the field name is (GLDGJ and GLDKJ)
select a.GLKCO as Company,a.GLMCU as BusinessUnit,a.GLOBJ as ObjectAccount,a.GLSUB as Subdiary,a.GLDGJ as GLDate, a.GLEXA as Explain1,a.GLEXR as Explain2, a.GLAA as ActualAmount,a.GLDOC as DocNo,a.GLJELN as JurnalLine,a.GLDKJ as Check_date, a.GLDCT as Doc_type,a.GLAN8 as AddressNum,b.WWMLNM + b.WWMLN1 as name from PRODDTA2.F0911,PRODDTA2.F0111 where GLCO in ('00700','00710') and GLOBJ='XXXX' and GLDGJ >=113001 and a.GLAN8=b.WWMLNM;
Can someone advise me?