3 Replies Latest reply: Oct 19, 2018 1:19 AM by Zhandos Shotan RSS

    Validate date with variable does not work

    Alex Valverde

      Regards,

      I have a variable with the date of Today:

       

      v_AñoAnt

      = Max (Year) -1

       

      v_FecFinAcumAnt

      AddYears (today (), -1)

       

      the expression validating the variable does not work:

      Sum ({<Año = {$ (v_AñoAnt)}, Fecha = {'<= $ (v_FecFinAcumAnt)'}, Mes =, EQUIPO =, Sector_Material =>} Sale_Neta) / 1000

       

      the expression validating the date directly if it works:

      Sum ({<Año = {$ (v_AñoAnt)}, Fecha = {'<= 10/16/2017'}, Mes =, EQUIPO =, Sector_Material =>} Sale_Neta) / 1000

       

      Can you tell me how to proceed

       

      Thank you.