Hi, I got no answer in the Crystal Reports forum so I will cross post here for advice.
I am looking for an Oracle driver that will convert Epoch time found in Remedy memo fields to standard date/time.
We have a join field in our Remedy database and our standard Oracle ODBC will not print Epoch time correctly while Remedy won't allow us to join those 2 tables (I can't explain the how or why, my Remedy knowledge is minimal). We do have an Oracle CR driver which does print it correctly, but as we are upgrading to Crystal Report 10, Oracle 9.0.2 and Remedy 6.3, we are losing this driver.
Does anyone have a recommendation as to what I could use to convert the Epoch time properly? When I say a memo field, I mean a diary field, which might have multiple entries.
This is what it will look like without me changing it :
Joe Helpdesk, 1127151144
-Client has a problem with her telephone
Joe Helpdesk, 1127151492
-Sending telco technician over
Joe Helpdesk, 1127151570
-Technician replaced faulty set
Thanks in advance,
Phil
I am looking for an Oracle driver that will convert Epoch time found in Remedy memo fields to standard date/time.
We have a join field in our Remedy database and our standard Oracle ODBC will not print Epoch time correctly while Remedy won't allow us to join those 2 tables (I can't explain the how or why, my Remedy knowledge is minimal). We do have an Oracle CR driver which does print it correctly, but as we are upgrading to Crystal Report 10, Oracle 9.0.2 and Remedy 6.3, we are losing this driver.
Does anyone have a recommendation as to what I could use to convert the Epoch time properly? When I say a memo field, I mean a diary field, which might have multiple entries.
This is what it will look like without me changing it :
Joe Helpdesk, 1127151144
-Client has a problem with her telephone
Joe Helpdesk, 1127151492
-Sending telco technician over
Joe Helpdesk, 1127151570
-Technician replaced faulty set
Thanks in advance,
Phil