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?