Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: fred.s on November 06, 2010, 09:11:24 AM

Title: **** System Date *****
Post by: fred.s on November 06, 2010, 09:11:24 AM

Hi can anyone tell me if there is a way of getting a system date( Todays date) in filters.

ie, to select any records ">= todays date" or "todays date -20"

Thanks in advance.....

Title: Re: **** System Date *****
Post by: Steve on November 06, 2010, 08:53:12 PM

Maybe if you gave us a clue.  ???

What are you trying to do? What do you want filtering?

Title: Re: **** System Date *****
Post by: fred.s on November 10, 2010, 10:38:12 AM

Dialing filters in config manager, on the call_time field!....

Title: Re: **** System Date *****
Post by: Steve on November 11, 2010, 02:18:30 PM

Fred - If you want people to help you really need to help them, give all the relevant information and say what you have done to try to solve your issue.

Dialling filters are just SQL scripts so the first step is to work it out in the database, I'm using Oracle and my call_time field is numeric (number of seconds since 1/1/1970). So I need to either convert SysDate to this format or convert call_time to a date. I'm converting SysDate and I want to find all records that were before today (less that SysDate).

[code]select call_time from my_table where call_time < ROUND(SysDate-(To_date('01011970','DDMMYYYY')))*86400[/code]

That should get you started.

Title: Re: **** System Date *****
Post by: fred.s on November 16, 2010, 06:48:23 PM

:)

Super, thank you.