18 Replies Latest reply: Dec 15, 2017 5:19 AM by Anand Chouhan RSS

    Date compraison

    souad ouertani

      I have a problem with a compound CLE field:

      dateID example

      20170401 (DATE)

      A2 (ID)

      CLE: 20170401A2

      so I need to extract the date 20170401 and sum the amount from 01/01/2017 to 20170401 (YTD)


      Sum({<CLE= {"=Left(CLE,8) > '20170101' and  <=$(=max(Left(CLE,8) ))"} >} COMPTE_ENCOURS_TND)