Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
can you help me with this expression plz:
I need to sum the Quantity for which the date is greater than today's date less than one year:
sum({$< DateMVT= {"(>=(date(today()-365)))"} >} Quantity)
Regards,
Yacine
Try
sum({$< DateMVT= {">=$(=date(today()-365)))"} >} Quantity)
DateMVT format should match the standard date format to make this work.
Instead of subtracting 365 days, you could also use addyears() function.
Hope this helps,
Stefan
Try
sum({$< DateMVT= {">=$(=date(today()-365)))"} >} Quantity)
DateMVT format should match the standard date format to make this work.
Instead of subtracting 365 days, you could also use addyears() function.
Hope this helps,
Stefan
the final expression :
=sum({$< DateMVT= {">=$(date(AddYears( today(),-1),'DD/MM/YYYY'))"} >} Quantity)