AnsweredAssumed Answered

Extract Year from Date Column in the layout using algorithm.

Question asked by malav on Oct 14, 2019
Latest reply on Oct 16, 2019 by malav

Hello all,

 

Is it possible to extract year from Date cube (the First Column in the Image) by using trim, Right/Left, Year function ?! 

by creating a Column algorithm in the layout itself ?

 

I am trying to get that and used various combinations of the same but no luck.

 

can any one please guide ?!

 

for example:

In the image below there is a  first Column with Date, i just need to extract Year from it and display in last column.

 

 

Looking for help on this one.

 

Warm Regards,

Malav 

Outcomes