1 Reply Latest reply on Sep 21, 2013 10:35 AM by philmodjunk

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

    bokenrosie

      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,