Help with creating a script
Can someone kindly help me create a script (including a button to perform the task) to search, find, and create a report of all records that fall within a specific date range on fields RDD1, RDD2 and RDD3. (These fields are renewal dates)
The range will always be as follows,
starting from current date (ie today's Date),
14 days before the dates displayed on fields RDD1, RDD2 and RDD3
21 days after the dates displayed on fields RDD1, RDD2 and RDD3.
I have attached 3 screenshot examples of the kind of records we have.