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
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
@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)!=0THENDateTimeAdd(tostring(Tonumber(Left([Ethiopian],4))+7)+'-09-10',((tonumber(Substring([Ethiopian],5,2))-1)*30)+Tonumber(RIGHT([Ethiopian],2)),'Day')ELSEDateTimeAdd(tostring(Tonumber(Left([Ethiopian],4))+7)+'-09-11',((tonumber(Substring([Ethiopian],5,2))-1)*30)+Tonumber(RIGHT([Ethiopian],2)),'Day')ENDIF
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
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
The date format looks normal. However, 2011-11-12 for example is actually 2019-07-19 in Gregorian format.
