Date format conversion

Help
1

I want to import dates from excel like 1/1/2018 and upload to a site in different format like 1-jan-2018. How to achieve this date conversion. Any suggestions.

2

You can use
Cdate(date in string).to string(dd-MMM-yyyy)

4

@syed1994

no need to declare the variable. instead of declare you can use like below

read range activity - output is DataTable DT1

u can use like this.

Cdate(DT1(“Date”).tostring).to string(dd-MMM-yyyy) —> where is DT1 is your datatable and “Date” is column name in excle sheet.

1 Like