how to create week field by using monthyear field

[#1]

i am having a field monthyear which shows 201302   yearmonth

by using this field i have to create week numbers

can anyone help me

[jagan]

Hi,

Try like this

=Week(MakeDate(Left(YearMonth), Right(2)))

Hope this helps you.

Regards,

Jagan.

[#3]

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