Hello, does anyone have a method to clculate the difference, in days from a retrieved date and the current system date provided by the date function in a strategy.
The idea is to flag records that have an activation date >= 75 days. It looks to be a tedious proccess without the use of a custom server.
Are there any folks that have used a DB dip to run a stored procedure out on ORCL? Anyway, any insight is greatly appreciated.
We are using Oracle stored procedure with URS, which among other things calculates the number of hours between the last and the current call.
Do you have trouble getting the results? Can you please tell me how I can help you!
Cheers!
THank you for the response. The goal is to implement the logic inside the strategy so as to limit the any calls to outside applications (customer servers or ORCL). The plan is to use the statistical tables configurable in CME. In the tables there will be 13 indices. For each month index there will be a value cooresponding to the number of days left in that year and the 13th indice will be a constant(1980) used to calculate if the current year is a leap year.
There will be a lot of stuff in the subroutine/strategy but the thinking is that since the logic is loaded in memory performance will be good.
Thank you again for the feedback.
Gary
Hello, Gary!
Do you need explanation of how to call Oracle procedure from URS and retrieve the results or did you get it already from other board members?
Perhaps a date condition, along the lines of:
CASE WHEN (Date in yymmdd format) = CONVERT (char,GETDATE()75,12) THEN 1 ELSE 0 END
In this instance, enter 1 as the condition, which will return today’s date minus 75 days.
Not sure if this is what you are after, but it works in Brio/VB (which really isn’t saying much!)
I hope this helps?
Tony
Hi, Tony,
that does not look like a stored procedure! 
Hi Vic,
It’s one I made up as I went along…!
Anything to help…