7 Replies Latest reply: Nov 7, 2015 8:40 AM by Henric Cronström RSS

    Month and year funtions not working

    FELIPE PEDRO

      I f I use like this works


      =Sum({<AnoAdmissao ={2015},MesAdmissao={10},DescricaoSituacao = {Ativo}>}Qtd_colaboradores)


      But when I use the script below it doesn't work:


      =Sum({<AnoAdmissao =Year(Today()),MesAdmissao=Month(Today()),DescricaoSituacao = {Ativo}>}Qtd_colaboradores)

       

      Could anyone help?