Report based on Calweek
I have seen many post in scn regarding week conversion from date, but i have this requirement that i struck upon.
In my report i have 2 manual entry variables called "Planned week from and planned week to". Here the user enters from week number say '21' and To week number say '24'. So then the data executed should be between those 3 weeks.
In my modelling i have calday and if i map it to calweek or i use a FM DATE_GET_WEEK i will get week number like 21, 22 etc. But as i have only one week number field, how do i create 2 user entry variables from calweek like "from week" and "To week".