1 Reply Latest reply: Aug 12, 2012 6:24 AM by mayilvahanan ramasamy RSS

    Select a date whose between 2 variables

    Ankri Laurent

      Hi

       

      I have the column DATE_SALAIRE that contains few dates in format dd/mm/yyyy

       

      I have created 2 date variables, that the user have to indicate :

      vDateSelectDebut

      vDateSelectFin

       

      I want to do the sum of the column MARGE_HT_FACTURATION where DATE_SALAIRE<=vDateSelectDebut and DATE_SALAIRE>=vDateSelectFin

       

      I have tested

      =SUM({<DATE_SALAIRE={'>=$(vDateSelectDebut)', DATE_SALAIRE={'<=$(vDateSelectFin)' }} MARGE_HT_FACTURATION)

      but it doesn't return me the both conditions together but if just one of them is checked

       

      For example, if

      vDateSelectDebut = 01/01/2012

      vDateSelectFin = 30/06/2012

      I want to select the lines where DATE_SALAIRE between 01/01/2012 and 30/06/2012

       

      Help please

       

      Thanks

       

      Laurent