Setting the previous year in set analysis

[Ribeiro]

I need to go back the previous year in the variable?

vMesAtual = Makedate(year(today()),month(today()),25);

vMesAnt = Makedate(year(today()-30),month(today()-30),25);

I need to fix the variable to bring 12/25/2017 = vMesAnt

But the variable must always be on the 25th of every month

Example:

vMesAnt :  25/12/2017

vMesAtual: 25/01/2018

any suggestion?

[sunny_talwar]

May be this

vMesAtual = MakeDate((Year(Today()) - 1), Month(Today()), 25);

or

vMesAtual = MakeDate(Year(AddYears(Today(), -1)), Month(Today()), 25);

[PrashantSangle]

Use addYear(YourExpression,-1)

Regards

[Ribeiro]

If the date is 2/25/2018 and 1/25/2018 will it work?

[sunny_talwar · Accepted solution]

Oh, you want to go just one month back? Try this

vMesAnt = AddMonths(MakeDate(Year(Today()), Month(Today()), 25), -1);

[YoussefBelloum]

Hi, try this

vMesAnt = Makedate(AddYears(today(),-1),month(today()-30),25);

[Ribeiro]

Thanks for your patience and competence.

[Ribeiro]

Sunny will be that the set analys is correct?

It is not bringing values...

vMesAtual = Makedate(year(today()),month(today()),25);

vMesAnt = AddMonths(MakeDate(Year(Today()), Month(Today()), 25), -1);

Sum({$<Ano =,Mes=,Date1 = {">= $(vMesAnt) <= $(vMesAtual)"},

[Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','ACE','FPV','CVE'},[Dt_Passou1]={'0'} >}Preco_Final)

[sunny_talwar]

Don't add spaces and then try this

Sum({$<Ano =,Mes=,Date1 = {">=$(=vMesAnt)<=$(=vMesAtual)"},

[Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','ACE','FPV','CVE'},[Dt_Passou1]={'0'} >}Preco_Final)

or this

Sum({$<Ano =,Mes=,Date1 = {">=$(=$(vMesAnt))<=$(=$(vMesAtual))"},

[Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','ACE','FPV','CVE'},[Dt_Passou1]={'0'} >}Preco_Final)

[Ribeiro]

Sum({$<Ano =,Mes=,Date1 = {">=$(=vMesAnt)<=$(=vMesAtual)"},

[Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','ACE','FPV','CVE'},[Dt_Passou1]={'0'} >}Preco_Final)