A client has requested a new query, specifically looking at outbound deliveries.
I have created a query that shows all deliveries with a departure date, and the arrival date (for this client, any delivery with a blank arrival date will trigger an action by a team member).
What I want to show, is the number of days that have elapsed between the departure date and today's date.
I have been able to create a new expression column and simply put in "date$" to add today's date to the report. However, instead of returning today's date I would like to calculate that elapsed number of days in that same column.
I've tried different expressions to do this (DATEDIFF("d",[F:SDH]DPEDAT,date$)) (most recently I've used date$-[F:SDH]DPEDAT), but each results in the error message:
@CAUAT0611.TRT/WMMZTSOAD2$adx (110) Type incompatibility
Any suggestions on the best method for accomplishing this?