'Concat' function in Graphical View

[BenedictV]

Hi,

I have a fiscal period field in my view which contains data in the format YYYYMMM, but I need to union this data with a table which has period in the format YYYYMM. Is there a way to convert yyyymmm into yyyymm.

1) I have mentioned 'concat' in the subject line because of thought of doing - concat(rightstr("FISCAL_YEAR_PER",4),leftstr("FISCAL_YEAR_PER",2)) but then graphical calc views do not have concat function. Is there a way solve this?

2) In general, how can a concatenation be achieved in a graphical view?

Thanks,

Benedict

[Former Member · Accepted solution]

Hello Felix,

Did you try achieving it this way,

rightstr("FISCAL_YEAR_PER",4) + leftstr("FISCAL_YEAR_PER",2)

Setting the datatype to "VARCHAR"

Regards,

Krishna

[BenedictV · Accepted solution]

That works. Thank you Krishna.

[Former Member · Accepted solution]

You are welcome Felix, Always happy to help

Regards,

Krishna