Hello, I have been trying to figure out how to write a find script that will find a specific date range. I have Issues that are out for a set amount of days and I would like to find the events that are with in those set amount of days. Also would like to automatically set it to either the current issue dates or the next issue dates.... I've screen shots for reference and hopefully help clarify what i'm trying to do... right now we just do the find 2 days before we go to print with this script....
Go to Layout [ Events List (Events) ]
Show All Records
Enter Find Mode
Set Field [Events::EventStartDate; Get ( CurrentDate ) & "..." & Get (CurrentDate) + 10]
Sort Records by Field [Ascending; Events::EventStartDate]
I don't really know how to get the correct "issue" to come up, I could just make a button for each issue but I feel like there is away to call up the next issue with one button I just have no idea how to do that...