Hi All, I have variable from excel in the format “20200408045500”. Date from this variable is in the format YYYYMMDDHHMMSS I want to convert it to dateTime Variable. Please help

in Assign, Datetime YourDT = Datetime.ParseExact(YourStr, “yyyyMMddhhmmss”, nothing)

@mohitkumar.gupta Try this : yourDateVar = DateTime.ParseExact(yourDateStr,“yyyyMMddHHmmss”,System.Globalization.CultureInfo.InvariantCulture) Note that the date will be in the format MM/dd/yyyy HH:mm:ss

@supermanPunch it works, Thanks

Extract datetime variable from a string, "20200408045500"

Learning Hub Academy Feedback

mz3bel (Mohssine HILAL) April 8, 2020, 12:33am 2

Hi @mohitkumar.gupta

Check this Convert string to date time - #3 by anil5

For the time, just add “hh:mm:ss”

Cheers

Topic		Replies	Views
How to convert a String value from current row in excel to date time variable Studio studio , question , workflow_diff	3	1331	December 12, 2022
DateTime conversion issue Academy Feedback	12	1395	June 17, 2019
How to convert string with datetime format "dd-MMM-yyyy" to "d/M/yyyy" Studio studio , question , activities_panel	14	387	July 22, 2024
Date and Time formatting from excel Help	13	2014	October 29, 2018
Convert string to date time Help	26	86943	June 10, 2022

Extract datetime variable from a string, "20200408045500"

Related topics