How to convert date format in excel from format 3-Nov-17 to 20171103

Help
1

Hi Everyone,

I need to convert eg. dd-mmm-yy this from column A to write it in the format eg. yyyymmdd column B. Kindly help to conert these dates from format of A Column to Format of Column B. Your valuable suggestions are welcome!

Thanks!

2

Hi @shweta.uipath,

  • use For each row activity
  • Row(“ColumnB”). tostring = Convert.todatetime(Row(“ColumnA”). tostring).tostring(“yyyymmdd”)
3

Hello @shweta.uipath

See example attached
ConvertDate.xaml (10.3 KB)
ConvertDate.xlsx (8.1 KB)

Let me know if it’s working

Hope it Helps :wink: