Fiscal year format

[Danny Ng]

Hi all,

I hope you can help me. I have a variable fiscalyear with different format within one variable

No.	fiscalyear
1	2008/09
2	2007-08
3	2010/11
4	2011-12

How can I change them to the same format (YYYY/YY)?

Thank you so much for your consideration.

[Clyde Schechter]

replace fiscalyear = subinstr(fiscalyear, "-", "/", .)

[Danny Ng]

Thanks Clyde. That answered my question