Week to Month

[diego_vazquez]

Hello everyone.

I have a field that shows a date in this format: '201625'

This is the year and the week concatenated.

My problem is that I have to extract the month from that field and I don't know how.

All the help in that subject would be apreciated.

Thanks

[diego_vazquez]

solved! Date(MakeWeekDate(Left(week,4),Right(week,2)),'YYYYMMM')