Ethiopian date conversion

[RSLippe]

Dear all,

I am currently working with the date which is recorded in the Ethiopian calendar format. Is there a way in Alteryx to convert it into Gregorian?

Many thanks in advance

[wdavis]

Hi @RSLippe 

Would you be able to provide some sample data which is in the Ethiopian Calendar Format? This is something I'm not familiar with, but sure Alteryx will be able to convert.

Thanks

Will

[RSLippe]

The date format looks normal. However, 2011-11-12 for example is actually  2019-07-19 in Gregorian format.

[wdavis]

Hi @RSLippe 

I have been unable to find somewhere online which has an exact way of calculating the Gregorian date from the Ethiopian. If you were able to find this, it would be possible to build this logic into Alteryx.

For example, at a very rough calculation, the Ethiopian calendar is 92 months behind the Gregorian. So if you use the formula - DateTimeAdd([YourFieldName],92,"months") 

Then it would get you close, however this is not the exact solution you are after! Somebody else on the Community however may have the solution for you.

Thanks

Will

[OllieClarke · Accepted solution]

Hi @RSLippe I've attached a workflow which should convert Ethiopian dates to Gregorian dates following the description of the process here 
I didn't have a lot of converted dates to check it against, so it might be worth checking the output, but hopefully that helps,

Ollie

[OllieClarke · Accepted solution]

@RSLippe  If you wanted it in one formula then this should do it (where [Ethiopian] is your date formatted yyyy-MM-dd):

---

IF Mod(tonumber(left([Ethiopian],4)),4)!=0

THEN

DateTimeAdd(tostring(Tonumber(Left([Ethiopian],4))+7)+'-09-10',((tonumber(Substring([Ethiopian],5,2))-1)*30)+Tonumber(RIGHT([Ethiopian],2)),'Day')

ELSE

DateTimeAdd(tostring(Tonumber(Left([Ethiopian],4))+7)+'-09-11',((tonumber(Substring([Ethiopian],5,2))-1)*30)+Tonumber(RIGHT([Ethiopian],2)),'Day')

ENDIF

[RSLippe]

thanks a lot. it works well.