How to convert dd-MMM-yy to yyyy.MM.dd format?

Help Studio
, ,
8

Hi,
Hi,
while reading the Datatable in Readrange Activity.
Enable “PreserveFormat” in Option in Property Panel.

So it will Get perserve text format, then u can use normally

use For Each Row in Data Table
inside the For each
Assign=>
Str1=(Cdate(currentRow(“ColumnName”).ToString)).Tostring(“yyyy.MM.dd”)

Regards,
Harivishnu