AnsweredAssumed Answered

Date Scripts

Question asked by LynnRogers on Aug 5, 2013
Latest reply on Aug 6, 2013 by LynnRogers

Title

Date Scripts

Post

     I have worked on this and I can not figure it out. Need help please. I am using FM Pro 12 Advance and I need a script that can find dates in multiple fields. I have a table named Work Order and it has 6 date fields. 5 of them represent up to 5 different times I have worked on a peace of equipment and they are on the layout named Date 1, Date 2, Date 3, Date 4, & Date 5. The sixth date field is not on the layout and is named Select Date. I need a script that when I put a date into the Select date field it will search all 5 date fields (Date 1, Date 2, Date 3.....looking for all matching dates.

Outcomes