Calendar: Start Date, End Date & everything in between

[ciaran_mcgowan]

Hi all,

I'm looking to create a calendar that will display all active employees in a company for the date selected. The only fields I have to work with is the Start_Date & End_Date in the Employee table. I want to create a calendar object where if I select a day it will show me all employees where:

Start_Date <= selected date <= End_Date

Is that just a matter of setting min date as the Start_Date and the max date as End_Date in the master calendar script? Or do I need to create a variable?

Can anyone help?

[Gysbert_Wassenaar · Accepted solution]

See this blog post for the answer: Creating Reference Dates for Intervals

[Anonymous]

I prefer to use 2 seperate variables. one for Start Date and another for End Date and Do the comparison of the dates in the expressions using set analysis

Sum({<selected_date={'>= $(vStartDate) <=$(vEndDate)'}>}Measurename)