I'm having difficulty passing the results of a formula to the select criteria when querying a remedy oracle database. I have Start and End date parameters that the user chooses through the calendar prompts that I want to pass to the remedy query. Problem is the "Last_Resolved_Date" field that I am querying requires the 10 digit equivalent of the date/time and not the standard date/time format that the user would select. I've created a formula to convert the std date/time value into the 10 digit format but cannot pass that value from the formula into the select criteria statement. I tried the following but it comes back with zero records:

This is the formula to convert the Oracle value to Date/Time format:

10-digit numeric

Edited by DNKNY - 25 Jul 2011 at 4:56am

Thanks, that worked great. I placed that formula in the Select criteria and got back the appropriate records.

Now my problem is the time zone of the data. Is there an option on that formula to adjust for GMT? The time value of one of the records should be 1:48 pm but it reports 6:48 pm.

Thanks. I got it. I found an epoch date converter tabel for time zones. Just subtract 18000 seconds from the UTC to get EST.