**** System Date *****

[fred.s]

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.....

[Steve]

Maybe if you gave us a clue. 

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

[fred.s]

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

[Steve]

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.

[fred.s]

Super, thank you.