Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
May be remove = sign and Try this?
BOOKING_DATE = {"<=$(=AddYears(date(Today(),'dd-MM-yyyy'), -1))"}
BOOKING_DATE={"<=$(=Date(addYears(Today(),-1),'DD-MM-YYYY')"},
Regards,
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)
I believe you missed a closing parenthesis
BOOKING_DATE={"<=$(=Date(addYears(Today(),-1),'DD-MM-YYYY'))"},
thanks..
That was easy!!!
Thanks so much. I keep learning