1 Year selection, 2 date fields

[pauldamen]

All,

I have a project dashboard with projects obviously having a start date and a end date. I have a mastercalender based on the 2 date fields.

But when I have my year selection box and I select 1 year it only shows the projects that have a startdate that year. How can I make a year selection and see both the projects starting that year, but also projects ending that year and running throughout that year?

Regards, Paul

[MK_QSL]

Create Canonical Calendar and use Year from this calendar.

Canonical Date

[pauldamen · Accepted solution]

Ok the solution proved to be quite simple, I just had to load:

StartDate, EndDate          as Year

Regards, Paul

[Anonymous]

check this as well:

Using Multiple Dates With Master Calendar

Master Calendar Date from Multiple dates in dataset