Skip to Content
Former Member
Nov 03, 2015 at 11:39 PM

DateDiff Crystal SQL Command


Hi, is it possible to use DateDiff in a Crystal SQL Command?

I have tried this:

(last_date_of_service is a field in my database)

Select ...., DateDiff("d", last_date_of_service, Date) As "DAYS"

From mytable as "mt"

I get this error <A term expected, beginning with either of: udentifier, constant, aggregate, $$, (, :, +..... or %Upper^Sele [Database Vendor Code:12]