Start and end dates connection in master calendar

[nicolai_moller]

Hi

I have a list of activities that each contains a startdate and an enddate.

I'm trying to implement a master calendar, but I can't figure out how to connect

the year field in the master calendar to both the startdate year and enddate year.

In my year listbox I can select a year but it only shows activities with enddates in that year,

where I want it to show all activities that has either a startdate or enddate or both, in that year.

Thanks.

[RedSky001]

Sorry got a bit distracted at work.

See the attachment.

You need to create your own private key if you have nulls

RowNo() AS Key...

[nicolai_moller]

Shouldn't it still work if I just leave it as you wrote, or do I need to change the key?

I have uploaded the document to load from the table in this thread.

[RedSky001]

How can an activity have an end date and no start date and seems a little illogical. ?

Can't you set the date to a default date if it is null ?

[nicolai_moller]

There are some activites that contains enddates but no startdates.

In case of no startdate, I could possibly create a temporary startdate that has the same year as the enddate, but it should then be overwritten if an actual startdate pops up in the data.

[RedSky001 · Accepted solution]

That sounds very sensbile, I think you'll find the data model will work then.  Also I notice you have a synthetic key, you can drop the temp data to get rid of this.