The YouTube video at: Selecting Arbitrary Date Ranges - YouTube provides a previously working approach to creating a "From" and "To" Calendar such that data between the two selections is displayed. I have had this working on several projects but now........
When I delete the two working calendar objects and try to create two new calendar objects using a different date field, I no longer get my date selections appearing in the "Current Selections Box" and the selection criteria no longer works.
To avoid any conflicts I have also tried to create an entirely new .qvw but amazingly, the approach does not work there either.
The date field I am using for selection appears correctly in a List Box as YYYY-MM-DD.
I have deleted and recreated the variables vStartDate and vEndDate several times and have correspondingly re-created the Triggers that govern how the data is entered. I have also created two entirely new variables as vPostStartDate and vPostEndDate but and used these instead but get no difference in outcome
I can see how I might have screwed up the first .qvw, but when I recreate the .qvw in a completely separate document, I don't get how the problem continues on.
Is there some way to delete any/all Trigger functions to re-establish the playing field?
The video above is straightforward and has worked perfectly for me in the past. But trying to make changes to it has been a tough slog.
I am sure that lots of folk need dynamic calendars and the video is good for an initial creation. But changing the field to be used for date selection has been hopeless to date.
I have QV Desktop and cannot process any 3rd party modification to the .qvw file that I am having trouble with. I have attached the .qvw below. It is a really simple problem and as I said in the first post, it has worked before. What I really want to know is if I have somehow compromised the Trigger function in the Settings file.
Thanks for your tip. It was a problem with the date field. All other dates in the document were in YYYYMMDD format. But in this case, it was actually coming in with date formatting as YYYY/MM/DD. The slashes were causing the problem.
