# Convert julian calendar to gregorian calendar

**URL:** <https://community.easymorph.com/t/convert-julian-calendar-to-gregorian-calendar/2978>\
**Category:** Support\
**Created:** [August 19, 2021, 6:57am UTC](https://community.easymorph.com/t/convert-julian-calendar-to-gregorian-calendar/2978 "2021-08-19T06:57:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![csofonio](https://community.easymorph.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@csofonio](https://community.easymorph.com/u/csofonio)\
**Post date:** [August 19, 2021, 6:57am UTC](https://community.easymorph.com/t/convert-julian-calendar-to-gregorian-calendar/2978/1 "2021-08-19T06:57:15Z")

</div>

Hi everyone,

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

Thank you in advanced.  
🙂

---

<div class="post-metadata">

**Author:** ![csofonio](https://community.easymorph.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@csofonio](https://community.easymorph.com/u/csofonio)\
**Post date:** [August 19, 2021, 9:44am UTC](https://community.easymorph.com/t/convert-julian-calendar-to-gregorian-calendar/2978/2 "2021-08-19T09:44:27Z")

</div>

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.

🙂