7 Replies Latest reply: Apr 22, 2017 11:08 AM by agnaldo neves

# I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

Returns me due date to date today: It's OK

Sum({\$<Anor ={\$(=Year(today()))}, Mêsr={\$(=Month(today()))}, Diar={'<=\$(=Day(Today()))'} >} VALOR_EMIS_NOVO_REC)

#### I need you to bring me to the current month.?

Example:

Month        Valor

Abr            125.000,00

Mar           854.000.00

Fev           822.000,00

Jan           322.000.00

Example set analysis: It's OK

Sum({\$<Anor ={\$(=Year(today()))}, Mêsr={\$(=Month(today()))}, Diar={'<=\$(=Day(Today()))'} >} VALOR_EMIS_NOVO_REC)

• ###### Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

From this data set.

Example:

Month        Valor

Abr            125.000,00

Mar           854.000.00

Fev           822.000,00

Jan           322.000.00

Are you expecting this?

Abr            125.000,00

• ###### Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

So you want the full month? then remove the day part of set analysis

Sum({\$<Anor ={\$(=Year(today()))}, Mêsr={\$(=Month(today()))}, Diar={'<=\$(=Day(Today()))'} >} VALOR_EMIS_NOVO_REC)

and use just this

Sum({\$<Anor ={\$(=Year(today()))}, Mêsr={\$(=Month(today()))}>} VALOR_EMIS_NOVO_REC)

or if you want only till March, then

Sum({\$<Anor ={\$(=Year(today()))}, Mêsr={"<\$(=Month(today()))"}>} VALOR_EMIS_NOVO_REC)

• ###### Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

Preciso do corrente ano, até o mês atual, até o dia atual,.

That is the date until today

A data tem continuidade, mais do que o mês e hoje

Exemplo:

NÃO,

Sum ({\$ <Anor = {\$ (= Ano (hoje ()))}, MESR = {\$ (= mês (hoje ()))}

>} VALOR_EMIS_NOVO_REC)

• ###### Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

ok, Please post some sample data

• ###### Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

Example attachment

• ###### Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

May be use this in your expression

CalendarDater = {"<=\$(=Date(Today(), 'DD-MMM-YYYY'))"}

• ###### Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

Did not work