AnsweredAssumed Answered

Script to Find non-blank in with OR on two fields

Question asked by bokenrosie on Sep 21, 2013
Latest reply on Sep 21, 2013 by philmodjunk

Title

Script to Find non-blank in with OR on two fields

Post

     I am trying find records that are not blank in two fields.

     In english I would say "Filemaker, please show me all records that have some value in either DATEFIELD1 or  DATEFIELD2" or both.

     In find mode I put a * in one or the other and it works fine.

     I tried to create a script that finds records first, then extends found set with the second date but that does not work.

     Thanks,

Outcomes