Need help in expression

[#1]

Hello Friends,

I have column name as Invoice Date it contains value of YYYY-MM-DD like (2011-01-23), my requirement is I need to create dimention like Jan 2011.

I tried YearMonth(Invoice_Date) in script level and in expression level.

I am not getting any solution for that, could you please any one suggest a way to show Monthname and Year.

Regards

Chriss

[nagaiank]

Try

MonthName(Invoice_Date)

For 2011-01-23, this will return 'Jan 2011'

[#3]

Hello chrismervin,

have you tried to use the date function?

like  date(Invoice_Date,'MM YYYY') ?

Regards,

Aylin

[#4]

Hello Sir,

Thanks a lot it works

Regards

Chriss