Arbitrary Date Ranges & Alternate States

[#1]

Hey everyone.

I followed this video to create arbitrary date ranges:

https://www.youtube.com/watch?v=UTDyO68BYL8

This works perfectly! very nice instruction.

However, once I try to make alternate states for this, it refuses to work.

The Graphs won't update and neither does the Date range as seen below:

Everything in the sheet is in either state 1 (left side) or state 2 (right side) exept for the middle 2, wich i need to add later as they need to affect both situations.

Now before putting it into states i could simply use the Date selection in Start Date or End Date to select a range and the Datum table would update automaticly.

As you can see now, as soon as i select another range it will only affect the other calender selection option.

Wich is crazy as they are in different states.

Now its probably something simple as putting another variable somewhere but after 2 hours i cannot seem to find where!

When i made the same worksheet with just date selection instead of calender it did work btw.

But i need a calender to select specific ranges wich varry every time we use this worksheet.

Can someone please help me, or does someone have an example?
I even tried putting every single expression in { State} but that didn't work either.

Kind Regards.

Mike Cleven.

[#2 · Accepted solution]

Fixed the issue.

had to create a secondary list of dates with a different name \ in the script.