AnsweredAssumed Answered

Find date range script

Question asked by taryn on May 22, 2018
Latest reply on Jun 10, 2018 by keywords

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]

Perform Find

Sort Records by Field [Ascending; Events::EventStartDate]

 

Screen Shot 2018-05-22 at 2.04.16 PM.pngScreen Shot 2018-05-22 at 2.04.34 PM.png

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...

Outcomes