How to change datatype of (now.date) from date to string

[treesa.maria]

Hi @mu_nazza

Use convert([columnname], ‘System.String’) in the select statement while specifying the column

Refer this link:

Changing data table column from datetime to string

Hi, Please, can someone help me with changing datatype of column in datatable. I got data table from database, and I need to change Date column from datetime to string format, because I need to put inside Date column date in format ddMMyyyy. How can I do it? Thanks!