Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a requirement wherein I would want to get the orders which got delayed by 10 days on shipment.So to get the same I have written a expression like this
count({<shipmentdate={>=$(=date((orderdate+5),'DD/MM/YYYY')}>}orderid)a
But it is not giving me the desired results.So can anyone please help me on the same
=count({$<orderid={"=(shipmentdate>=(orderdate+10))"}>} orderid)
like this
=count({<shipmentdate={">=$(=date((orderdate+5),'DD/MM/YYYY')<=$(=date((orderdate+10),'DD/MM/YYYY')"}>}orderid)