DTStoDateTime 1

[jwa6]

Hi

I am converting a CR v 7 report to CR 8.5. I have some minute calculations that are being done as you can se below:

I get an error w/ the DTStoDateTime in CR 8.5. Error is ' a string is required here" on the below formula
This is the format of the field I am trying to convert to a date/time : (oracle date/time)

the report option is set to date-time

formats are {ETIME_INITIATOR.CREATION_DATE} = "2001/04/09 09:02:27.00"
and ({DATA_SERVICE_PACKET.CREATION_DATE} = "2001/04/09 08:58:59.00"

the report tool has them as string (22) but i use oracle alot. They are date/time in oracle.
why the string 22 he says?


DateTimetoTime(DTStoDateTime({DATA_SERVICE_PACKET.CREATION_DATE}))- DateTimetoTime(DTStoDateTime({ETIME_INITIATOR.CREATION_DATE}))

I understand the DTStoDateTime is no longer supported. I have tried

DateValue and DateTimeValue and cdate ...but same error

any thoughts?

jim

 

[synapsevampire]

Check the connectivity that you're using, this is very important and should be included with posts to get an accurate answer for Oracle.

Either use the native connectivity or the CR supplied ODBC driver.

Your version of Oracle may also be important, so try including more technical information.

I also use Oracle a lot, and I use datetime fields every day without a hitch. The rub is usually that the wrong connectivity is used, or you're using an unsupported data type, such as timestamp with timezone.

-k