Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I changed a lot but still cannot figure out:
count({<[deliverydate.autoCalendar.Date]={"<=$(=Date(today())-30)"}>}Delivery)
Count the Deliveryno. older than thirty days from today .
I always got wrong value.
Hope someone can help.
Thanks a lot.
Best.
after replacing the date format with your own try below date part of the expression
Date(today()-30, 'DD-MMM-YYYY')
count({<[deliverydate.autoCalendar.Date]={"<=$(=Date(today()-30, 'DD-MMM-YYYY'))"}>}Delivery)
after replacing the date format with your own try below date part of the expression
Date(today()-30, 'DD-MMM-YYYY')
count({<[deliverydate.autoCalendar.Date]={"<=$(=Date(today()-30, 'DD-MMM-YYYY'))"}>}Delivery)