Add alphanumeric column

Question

I want to add a simple year and period column to an output but it must be in the format of 2023P08. I thought just adding as a V_String would be ok but I keep getting 'Error: Formula (11): Parse Error at char(0): An operator must be between operands (Expression #1)'

How best to add this in?

Thanks

DenisZ · Answer

Numeric and string fields cannot be joined alone. Since you are looking for a P in the middle you would need to covert your year and month to string fields using ToString([Name]) and then add a P in " ".

Hope it helps

rogersm01 · Answer

thanks for your help - much appreciated

binu_acs · Answer

@rogersm01 Looking for something like the one below?

Year_Period_1123.yxmd