How to change entire datatble date column to change as "YYYY-MM-dd" format?

Pls help guys


First read your excel with read range activity

Take for each row activity

For each row in datatable(your read range output)

(Inside for each loop)

Create date time variable

Your datetime variable = cdate(row(0).tostring)

Now, datetime variable.tostring(“yyyy-MM-dd”)

Hope this helps,

Aman sheik

1 Like

it has large number of datas so any easy way using linq like that