I am trying to pull a sql date/time value from a Microsoft SQL 2000 database and assign the value to a local variable in an IP IVR script. I have tried creating both Date and Time variables however when I try to assign the value with DB Get Resource neither one shows up in the drop down menu in CCX script editor. Do I need to do some data conversion with constructors or such? Basically what I am trying to do is compare the current date and time to a date and time stored in a database.
I have this problem too.