I am trying to subtract two list of dates - but can not figure out how to do it.
I have an table - Order, with the following fields:
I want to find out the average delivery time in days for a given city (so I can display expected delivery date when a user enter city name/pin code). How do I subtract the list of “delivery_date” and “order_date”?
Thanks for the help
@romanmg gaby - have you encountered this?
Yes, you can do this be creating a number field under your Order type called “Delivery_Time”. When Delivery Date is ready to be saved to the order, you’d make a change to the order:
Delivery_Time = Delivery_Date minus Order_Date :formatted as days
Then to display the average to the user in a text element, you can do a search: Search for Orders Delivery_Time :average. The search should also have the city constraint.
Hope this helps!
thanks @romanmg. So no way to do calculations like these (maths on two lists) on the fly?
This topic was automatically closed after 70 days. New replies are no longer allowed.