AddYears in set analysis

[Anonymous]

Hi All

I have below expression where I want to subtract a year from todays date. However, it seems like the expression doesn't evaluate.

Can anyone help, I guess as usual it's something smaller detail I'm missing

Sum({$<CAL_YEAR = {$(=only(CAL_YEAR)-1)}, CAL_MONTH = {$(=Num(Max(CAL_MONTH), '00'))}, BOOKING_DATE = {"<=$(=AddYears(=date(Today(),'dd-MM-yyyy'))-1)"} >} New_NET)

Regards

Stefan

[Anil_Babu_Samineni]

May be remove = sign and Try this?

BOOKING_DATE = {"<=$(=AddYears(date(Today(),'dd-MM-yyyy'), -1))"}

[PrashantSangle]

BOOKING_DATE={"<=$(=Date(addYears(Today(),-1),'DD-MM-YYYY')"},

Regards,

[sunny_talwar · Accepted solution]

May be this

Sum({$<CAL_YEAR = {$(=only(CAL_YEAR)-1)}, CAL_MONTH = {$(=Num(Max(CAL_MONTH), '00'))}, BOOKING_DATE = {"<=$(=Date(AddYears(Today(), -1), 'DD-MM-YYYY'))"}>} New_NET)

[sunny_talwar]

I believe you missed a closing parenthesis

BOOKING_DATE={"<=$(=Date(addYears(Today(),-1),'DD-MM-YYYY'))"},

[PrashantSangle]

thanks..

[Anonymous]

That was easy!!!

Thanks so much. I keep learning