Hi, I have to take out a column which is date actually but in excel it will be in string format. that need to convert into data and minus with date.now and that minus between both date should reflect in message box. How to do it? can any one help i m stuck to convert that excel row from string …

Date conversion issue

PrankurJoshi (Prankur Joshi) September 2, 2018, 12:46pm 3

See this for conversion of string to date -

After this you can manipulate the date by adding or removing number of days like date.AddDays or by comparing dates

See this

Topic		Replies	Views
Date showing in excel and in the data table are different and needs conversion Activities datatable , uiautomation , activities , error	5	1721	March 24, 2021
Convert integer to date Help datatable , excel , string , question	4	838	June 19, 2020
Converting String column in a DataTable to DateTime Studio datatable , uiautomation , activities , error	4	3743	October 6, 2020
Converting integer to date format in excel Help excel , uiautomation , studio	5	2905	September 19, 2019
Convert a string to Date format Activities excel , activities , question	10	9138	January 8, 2022