3 Replies Latest reply: Apr 2, 2011 8:25 AM by Fernando Suzuki RSS

    OR and NULL in set analysis

      Hello,

       

      I have a problem with my set analysis:

      I want count my users who is in my company in a date selected by a filter year or month..

      For this I have a date of Arrival of my user and I hva maybe A date of finish.

       

      My Expression is :

      count({$<[Date d'Effet]={"<=$(=Date(max(Date),'DD/MM/YYYY'))"},[Date de Fin]={">=$(=Date(min(Date),'DD/MM/YYYY'))"}>+
      <[Date d'Effet]={"<=$(=Date(max(Date),'DD/MM/YYYY'))"},[Date de Fin]={""}>}MatriculeCollab)

      I have two cases : One My date of finish is not in the database and my users are in my selection. Or this date are wrtie and in this case It must be superior or equal to the minimum of my date selected (Year, Month)

       

      With this set Analysis I succed to have the users who have date of finish but not who don't have date of finish.

       

      Can you help me please?

      Kind Regards