6 Replies Latest reply: Mar 14, 2018 9:48 AM by Axel Beaugrand RSS

    if match : Confirm function :

    Axel Beaugrand



      Can someone please tell me if it's possible to use Match function in my request?

      In my application I've two differents date: entry and exit


      I created a special calendar in order to know the numbers of présents, I find the solution by intervalmatch..


      Now, I would like to calculate the numbers of peole entry and exit :

      I've no idea to translate this condition in my table...


      I tried the condition but is not working.

      Maybe I need to use the if match but any one can help me.

      if(Entry_date = Present_date,1,0) as Flag_Enty