Hi everyone,
I need to convert a Julian Oracle JDE date to Gregorian format.
How can I do it?
Thank you in advanced.
Hi everyone,
I need to convert a Julian Oracle JDE date to Gregorian format.
How can I do it?
Thank you in advanced.
I found the solution and I share it for every member who has the same problem.
I had to create a new calculated field with this formula:
format(Date(if(asnumber(LEFT([SHTRDJ],1))>=1,20,19)&MID([SHTRDJ],1,2)&‘0101’,‘yyyyMMdd’)+asnumber(Right([SHTRDJ],3)),‘yyyyMMdd’)
Where [SHTRDJ] is my data field.