How to get disply value by concatenating 2 columns

[#1]

Hi,

I have 2 columns Month(Jan, Feb, Mar....) and CalendaryYear(2011,2012,2013),

My requirement is i have to concatenate those 2 columns for that i am using below condition

Month & '-' & CalendaryYear as month

from this will get output like Jan-2011,Feb-2011,..

But i have to disply it like Jan-11,Feb-11,.....

Can any one suggest me to get this..

Thanks ,

Sh

[simondachstr]

Month & '-' & right(CalendaryYear,2)

[whiteline · Accepted solution]

Hi.

Month & '-' & Right(CalendaryYear,2)

[jonathandienst]

Hi

Or you could do this as a date value. This will mean that it will sort correctly (sort numerical):

Date(Date#(Month & ' ' CalendarYear, 'MMM YYYY'), 'MMM-YY')

Regards

Jonathan