About EasyMorph Tutorials & Examples Web-help

Convert julian calendar to gregorian calendar

Hi everyone,

I need to convert a Julian Oracle JDE date to Gregorian format.
How can I do it?

Thank you in advanced.
:slight_smile:

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.

:slight_smile:

To learn more about EasyMorph visit easymorph.com.