Difference Between Start and End TimeStamps 2

[SonOfZeus]

When using the following formula in Crystal reports 8.5: DATEDIFF("n", {t_TicketHeader.th_StartTimeStamp}, {t_TicketHeader.th_EndTimeStamp})

It fails to recognize the function or the 2 fields being Datetime values. When the SQL is run in SQL Server 2000, it runs fine with results being accurate. Does anyone know what is wrong because it is linked to that same server and it's data

 

[synapsevampire]

Verify that the following is set:

File->Report Options->Convert Date-Time Field = To Date-Time

If that doesn't resolve, do the date fields demonstrate as datetime fields if you right click and say browse?

And what does It "fails to recognize the function" equate to, it gives you an error?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[SonOfZeus]

You were right in the report options, it isn't something I'd encountered over the years.

Thanks