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

How to get date in UCCX script from Database

Hi.

I have configured simple script for testing purpose and now available to get any single field from database and write this field to UCCX  variable.

Now i need to perform such query:

select convert(varchar(10), getdate(), 111)

It returns date in SQL.

Is it possible to write it to UCCX variable in script using DB Read and DB Get steps?

Everyone's tags (8)
1 REPLY 1
Highlighted
Advocate

How to get date in UCCX script from Database

Hi,

sure, you need to alias it, e.g. SELECT CONVERT(VARCHAR(10), GETDATE(), 111) AS [MYDATE]

Don't forget to create a 'dummy' view containing the column MYDATE.

Or, if it's possible, create a view on your custom SQL. This is what I would recommend.

G.

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards