Month and year funtions not working

[Anonymous]

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?

[maxgro]

sum({$ <

     AnoAdmissao ={"$(=year(today()))"},

     MesAdmissao={"$(=num(month(today())))"},

     DescricaoSituacao={Ativo}>

     }

     Qtd_colaboradores)

[nizamsha]

=Sum({<AnoAdmissao =

{"$(=Year(Today()))"},

MesAdmissao={"$(=Date( Month(Today())),'MM')"},

DescricaoSituacao = {"Ativo"}>}Qtd_colaboradores)

[amithmurali]

sum({$ <

              AnoAdmissao = {"$( =year(today()))"},

              MesAdmissao = {"$( =num(month(today())))"},

              DescricaoSituacao ={Ativo}

         >} Qtd_colaboradores)

[Anonymous]

hi,

please try:

=Sum({$ <AnoAdmissao ={"$(=year(today()))"}, MesAdmissao={"$(=num(month(today())))"},

               DescricaoSituacao={Ativo}>}Qtd_colaboradores)

[Anonymous]

Thanks

[Chanty4u]

Please close the thread as correct.or helpful...hope this wil help to others while seaerchng

thanks

Suresh

[hic]

It is not possible to use normal functions in the position where you use them, since the parser expects a Set, i.e. either a {...} construction, or a Set function, E() or P().

See more on

A Primer on Set Analysis

Dates in Set Analysis

HIC