I believe this is a simple task but can't find an easy way to tackle it. I have records that contain many specific date fields. These date fields record when things happen as we progress through our jobs.
for example, in each record I have:
field name: (date_1) Start Job: Sept 12, 2017
field name: (date_2) 1st revisions: Sept 13, 2017
field name: (date_3) 2nd revisions: Sept 15, 2017
field name: (date_4) Proof read: Sept 17, 2017
field name: (date_5) To client: Sept 18, 2017
field name: (date_6) Complete: Sept 20, 2017
What I would like to do is create a script that allows me to search all records for a specific date.
... such as, "find all records (in these specific date fields) that include Sept 15, 2017" or any particular date.
It would be nice (but not necessary) to even have a drop down calendar in the find request.
I hope I have explained this well enough.