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

[Mohammad Ramadan A.Hafiez]

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

[Mohammad Ramadan A.Hafiez · Accepted solution]

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.