cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
260
Views
0
Helpful
1
Replies

CCX converting time value "string type" to time value "time type"

Hello Friends,

                   I have a ccx 12.5 and an application "script" that is used to run my call center.

Currenly I am in process of solving the calls that are Dequeued and apply priority to it.

I do this by storing the Deqeued DN and time in SQL DB table that contains PhoneNumber :string type and ActionTime: time(7) type.

I retrieve these values and store in the script in varialbled "DeqDN: string type, and DeqTime: string type.

I am at process of comparing the DeqTime and using the if step this time must be not more than 3 hours ago.

I need to use the IF step to make this math and decide:

T[now] == <DequTime  "time of now must be less than or equal DeqTime + 2 hours

Since I am not a developer, how to accomplish this check please?

TIA

1 Accepted Solution

Accepted Solutions

I couldn't solve it using the scripting since I am not a developer, but I solved it from the SQL DB it self by storing the record automatic time Default (getdate()) and another fieled as default (dateadd(hour,(2),getdate())).

this worked fine for me. 

View solution in original post

1 Reply 1

I couldn't solve it using the scripting since I am not a developer, but I solved it from the SQL DB it self by storing the record automatic time Default (getdate()) and another fieled as default (dateadd(hour,(2),getdate())).

this worked fine for me.