3 Replies Latest reply: Sep 20, 2016 1:26 PM by Sunny Talwar RSS

    Set Analysis Using Date Fields

    Casey Johnson

      New to Set Analysis and running into a snag. I'm trying to create a measure which looks for (2) empty date fields to evaluate the expression (or the opposite: looks for (2) fields with dates to evaluate the expression).


      ***FYI - The field dates are random dates ( if entered), or they are just blank fields. The dates are all formatted the same & correctly ***

       

      Here's what I have tried:

      1. count ( { $ < fieldA = {' '}, fieldB = {' '} > } stock_number ) if fields are blank
      2. count ( { $ < fieldA -= {'*'}, fieldB -= {'*'} > } stock_number ) if fields are NOT blank
      3. count({$<fieldA={'*'}-{''}, fieldB={'*'}-{''}>} stock_number) ??? found this somewhere ... if fields aren't blank & making them blank???

       

      I have been getting some mixed results with the above expressions if I only try one field at a time, but not both??? Anyone have any ideas?

       

      Thanks for your time! - Casey