Concatenate year and month field into date and join mastercalendar
I hope you can help me with the following problem.
From a data source I load a month field and a year field. By using the makedate function I concatenate those two fields to MM-YYYY as Date.
In my script I made a mastercalendar. The date in de mastercalendar (DD-MM-YYYY) is joined on the month and year field (Date) from the datasource, which I had concatenated. QV gets me the following result:
MM-YYYY from datasource
The make date function gives me automatically the first date of the month. When I select 01-01-2011 from the mastercalendar, I will get the figures from january 2011. That only works for the first of the month. When I for example select 08-01-2011 I would like to have january selected. At this moment that doesn't work. Does anyone know how to perform this?
I hope I am clear in the description of my wishes. Otherwise, ask me.
But still one question. If I don't make a selection on the DateKey, the table will be empty. Can I arrange that, if nothing is selected, all months will show up? And after making a selection, it will be the selected month?