Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am having a field monthyear which shows 201302 yearmonth
by using this field i have to create week numbers
can anyone help me
Hi,
Try like this
=Week(MakeDate(Left(YearMonth), Right(2)))
Hope this helps you.
Regards,
Jagan.
it is not working
i am using this
WeekName([ Date], 0, -1) as Week,
by this i am getting the week numbers and year but i need only week numbers year should not be shown