how to create the month by using week and monthyear

[#1]

can anyone help me in creating month by using week

and also monthyear by using month and year for exp 201301

[#2]

you can do MonthYear by MakeDate(Year,Month) but you cannot create out of month since 1 week can belong to 2 months

[srinivasa1]

Try MonthName And Year function EG

MontName(Week)

Year(week)

[#4]

my bad for monthyear by using month and year for exp 201301 use  Date(MakeDate(Year,Month),'YYYYMM')

[#5]

month(makedate(left('YearWeek',4)) + right('YearWeek',2)*7 -1) as Mon,

I am using this but can not see any values

before that I am creationg yearweek by using

YEAR & '-' & WEEK as YearWeek,

it is working

[rustyfishbones]

Hi You can try

Year(Date) & Month(Date) AS YearMonth , the result would be 2013Jan

    or try

Year(Date) & '/' & Month(Date) AS YearMonth. the result would be 2013/Jan

   or try this to make it look a little better

Year(Date) & ' / ' & Month(Date) AS YearMonth. the result would be 2013 / Jan

[#7]

can i use the same thisng to get Month and week

Date(MakeDate(Year,Week),'YYYYWW')

[#8]

Hi,

It's not possible create a month from a week, because a week could be in two months.

For a MonthYear, you can use Date(MakeDate(Year, Month), 'YYYY-MMM')

Regards,

Ricardo

[MayilVahanan]

HI

Try like this

= MakeWeekDate(Year,Week)

Edit:

= MonthName(MakeWeekDate(Year,Week)) for month year

or

= Month(MakeWeekDate(Year,Week)) for month