Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can anyone help me in creating month by using week
and also monthyear by using month and year for exp 201301
you can do MonthYear by MakeDate(Year,Month) but you cannot create out of month since 1 week can belong to 2 months
Try MonthName And Year function EG
MontName(Week)
Year(week)
my bad for monthyear by using month and year for exp 201301 use Date(MakeDate(Year,Month),'YYYYMM')
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
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
can i use the same thisng to get Month and week
Date(MakeDate(Year,Week),'YYYYWW')
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
HI
Try like this
= MakeWeekDate(Year,Week)
Edit:
= MonthName(MakeWeekDate(Year,Week)) for month year
or
= Month(MakeWeekDate(Year,Week)) for month