Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
diego_vazquez
Contributor III
Contributor III

Week to Month

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

1 Reply
diego_vazquez
Contributor III
Contributor III
Author

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