I need to subtract a field in my database that is a datetime field from the current date at the time the report is run.
Then I need the answer displayed in days, hours and minutes as shown here:
11d 21h 56m
This is a one time report so I don't need to use declared variables, etc., just something simple will do.
I have seen lots of examples using variables but do not know enough sequel to turn those into a simple query.
Can someone help?
My table/field is op.order_date.