how to convert “08/21/2018 08:06:55 PM” from excel row to “2018-08-21T20:06:55.0” format to other excel.

You can directly use this : DateAndTime.Now.ToString(“yyyy-MM-dd hh:mm:ss”)

How to convert date time

Himanshu.joshi (Himanshu Joshi) August 22, 2018, 2:03pm 4

Use This

Convert.ToDateTime(Your String Variable Of Date).ToString(“yyyy-MM-dd ‘T’ HH:mm:ss”)

Regards

Update

1 Like

Topic		Replies	Views
How to convert a String value from current row in excel to date time variable Studio studio , question , workflow_diff	3	879	December 12, 2022
How to convert datetime(1/21/2018 00:00:00) into date(1/21/2018) Help	6	4391	October 29, 2018
Convert to Date Time From String Something Else string , feedback , help , datetime , convert , string-and-date	19	9839	September 24, 2022
Convert date to dd/mm/yyyyy Help	7	2574	September 27, 2019
Convert date time format Academy Feedback excel	7	2724	August 23, 2020