11-28-2018 04:05 AM - edited 03-15-2019 06:43 AM
Folks please help...
I want to play DATE in 'YYYYMMDD' format from variable type 'string'
I have SQL 2008 External DB configured. I've configured variables in GETDB step to store the output from database table. Challenge im with is how should I play the date in above said format which is stored in 'expirydate' variable.
in SQL date format is YYYY/MM/DD.
regards,
Ritesh Desai.
11-28-2018 07:13 AM
11-28-2018 07:49 PM
Hey thanks Anthony for revert...
Yes I did refered UCCX Vol-2 scripting guide. I am stuck in setting logic after data captured from SQL DB and is stored in variable. Using variable type as 'date' or 'string' is not working, ot sure if I'm mistaken somewhere. During script debug, the dbget step is not executed, script ends with lady error announcement.
I did verify DB integration is fine. Queries works well. Any hint where i'm mistaken.
Thanks in advance...
regards,
Ritesh Desai.
11-28-2018 09:58 PM
11-29-2018 08:32 PM
@Anthony Holloway basically I'm running CCX dialer. In dialer lead structure, i'm using predefined account Number field which is populated with unique number i.e. "ciscoACno". With the help of Get Enterprise Call Info step using Variable "call.AccountNumber" and store in "ciscoACno"variable type "string". I'm trying to fetch date on basis of ciscoACno variable from SQL database. So in SQL database, i have table with 5 columns, firstname, lastname, ciscoACno, amount,date. On basis of ciscoACno i have to announce amount and date to caller.
Please suggest your expertise... appreciated your suggestion.
regards,
Ritesh Desai.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide