Yes this will do the trick, but Tableau prompts that MAKEDATE is unkown function!
Could you please elaboarate how makedate works or point me to the right direction?
I want to follow the logic of your calc field.
Thank you again!
1 of 1 people found this helpful
Check this simple calculations made it for Julian date conversion
Calc : STR((datepart('year',[Order Date])-1900))+str(datepart('dayofyear',[Order Date]))
Julian (YYYYDDD) :
Calc: Right(DATEname('year',[Order Date]),2)+str(DATEPART('dayofyear',[Order Date]))
Hope this helps kindly mark this answer as correct/helpful so that it will help others