Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a field OrderDate field, By this i have created the year, moth, Week
in this month i get 1 to 12 as a integer value
But i want YearMonth in
YearMonth
************
Jan-2012
Feb-2012.... and so on
how i can get this.
Please help me
The best way (in my mind) is to use
Date(MonthStart(OrderDate), 'MMM-YY') as YearMonth
HIC
Try using the MonthName() function.
Use this
MonthName([Calendar Date]) .
[Calendar Date] should be in "YYYY/MM/DD" format.
HI
Set the Date formt to 3-JAN-2012 like this
and then use MID(3-JAN-2012,3,10) --- gives JAN-2013
Thank you so much i works.
If i need MonthYear in the format
MonthYear
***********
Jan-12
Feb-12
How can i get. please tell me
date ( MonthName ( [YourDate] ) , 'MMM-YY' )
The best way (in my mind) is to use
Date(MonthStart(OrderDate), 'MMM-YY') as YearMonth
HIC
Try this
Date([Date Field], 'MMM-YY')
Thank you Mr.Henric Crostrom.
I got the answer.
You also try this way also
Date(MonthName(OrderDate), 'MMM-YY') as YearMonth