Master Calendar with Alternate States

[#1]

Hello,

I have assigned "Current Selections", "Year", "Quate", "Month", and all 4 textboxes to "State 1". I assigned "Default State" to "Start Date" and "End Date" objects.

I also created a master calendar and created variables and triggers.

TempCalendar:
LOAD
Date($(vStartDate) + RecNo()) as TempDate autogenerate $(vEndDate) - $(vStartDate);

MasterCalendar:
Load
TempDate as [Date]
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;

Before I use alternate state, it works. But after I assigned objects to State1, and when I choosing the "Start Date" and "End Date", the date values didn't show up in the "Current Selection" object and also didn't make any changes. So I am wondering how I could keep both master calander function and alternate state?

Thanks in advance,

Becky

[sunny_talwar]

Do you have a trigger to select a date range from default state to alternate state?

[#3]

Great point Sunny! I don't think I have one. So what should I do?

Select Trigger,  --> Field event trigger --> chosse the date field --> add Actions --> Select Field Action?

When I am adding Field Actions, what I should put in "Field", "Search String" and "Alternate State"?

Shall I put date field name in "Field"? "State1" in "Alternate State"?  What I should put in "Search String"?

[sunny_talwar]

Field = Date

Alternate State = State1

Search String -> ='>=' & Date(vStartDate, 'DD/MM/YYYY') & '<=' & Date(vEndDate, 'DD/MM/YYYY')

[sunny_talwar]

Question, is start and end date driven by a field or variables in your calendar object?

[#6]

Thanks Sunny. I believe your approach is the correct one. But somehow I cannot get the result. Also, I cannot clear the date range in "Current Selection" object.

I think probably there are other settings went wrong. I attached a sample QVW file. Do you mind to take a look and let me know where went wrong?

Thanks!

Becky

[#7]

Yes, the start and end date driven by the field "Receive_Date" in my sample qvw file. If that answered your question?

[sunny_talwar · Accepted solution]

Seems to be working if you use this search string:

='>=' & Date(vMinDate, 'DD/MM/YYYY') & '<=' & Date(vMaxDate, 'DD/MM/YYYY')

[#9]

I am all set! Thanks Sunny!

[sunny_talwar]

Great