" /> Date Comparison in IR Strategy - Genesys CTI User Forum
« previous next »
Pages: [1]   Go Down

Author Topic: Date Comparison in IR Strategy  (Read 4758 times)

Gary

  • Guest
Date Comparison in IR Strategy
« on: January 01, 1970, 12:00:00 AM »
Advertisement
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.
Logged

Pretty Girl

  • Guest
Date Comparison in IR Strategy
« Reply #1 on: January 01, 1970, 12:00:00 AM »
  • Best Answer
    • 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!
    Logged

    Gary

    • Guest
    Date Comparison in IR Strategy
    « Reply #2 on: January 01, 1970, 12:00:00 AM »
  • Best Answer
    • 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
    Logged

    Pretty Girl

    • Guest
    Date Comparison in IR Strategy
    « Reply #3 on: January 01, 1970, 12:00:00 AM »
  • Best Answer
    • 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?
    Logged

    Tony Tillyer

    • Guest
    Date Comparison in IR Strategy
    « Reply #4 on: January 01, 1970, 12:00:00 AM »
  • Best Answer
    • 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
    Logged

    VIC

    • Guest
    Date Comparison in IR Strategy
    « Reply #5 on: January 01, 1970, 12:00:00 AM »
  • Best Answer
    • Hi, Tony,

    that does not look like a stored procedure! :)
    Logged

    Tony Tillyer

    • Guest
    Date Comparison in IR Strategy
    « Reply #6 on: January 01, 1970, 12:00:00 AM »
  • Best Answer
    • Hi Vic,

    It's one I made up as I went along...! :)

    Anything to help...
    Logged
    Pages: [1]   Go Up
    « previous next »