Retrieving Month and Year

[#1]

I Have one Serial number Like 11061311012, the first six digits are date field. I am retrieving the those six digits means 110613 i.e date. I am using this field how can i retrieve the month and year like Jun-2013.

[swuehl]

Use

month(date#('110613','DDMMYY') )

resp. the year() function. (Edit: Or any other Date functions from the Help, like Monthname() )

[MK_QSL]

Use Below in your Script

Date(Date#(Left(11061311012,6),'DDMMYY')) as Date,

Month(Date#(Left(11061311012,6),'DDMMYY')) as Month,

Year(Date#(Left(11061311012,6),'DDMMYY')) as Year,

Date(Date#(Left(11061311012,6),'DDMMYY'),'MMMM-YYYY') as Month-Year

you can replace 11061311012 with your DateField

Hope this helps..

[jagan]

Hi Kiran,

Try like this

=Date(date#(Left('11061311012'),'DDMMYY'), 'MMM-YYYY' )

Or

=Date(date#(Left(DimensionName),'DDMMYY'), 'MMM-YYYY' )

Regards,

Jagan.

[its_anandrjs]

You can write like

=Date(Date#(left(YourDateDimension,6),'DDMMYY'),'MMM-YYYY')

Or

=MonthName(Date#(left(Date,6),'DDMMYY'))