Play DATE in UCCX 11.6

[Ritesh Desai]

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.

[Anthony Holloway]

Have you checked the documentation for the Create Generated Prompt step?

It's in the Editor Step Reference Guide on page 171 (Linked Below)

https://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_11_0/programming/guide/EditorSeriesVol2.pdf

[Ritesh Desai]

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. 

[Anthony Holloway]

Sounds like a DB issue and not a playing the date issue, correct?

[Ritesh Desai]

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