Find a date within specific date fields, in all records

Discussion created by argus2 on Sep 20, 2017
Latest reply on Sep 21, 2017 by bigtom

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.