How to get date in UCCX script from Database

[Oleh Doroshenko]

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?

[Gergely Szabo]

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.