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

    if match : Confirm function :

    Axel Beaugrand

      Hi,

       

      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

       

      Thanks!

       

      A.