I have data in excel like this [image] No problem for read data from excel but my issues i need to do something like this => check current time is valid period for Start_bot or not ? Example : current_time => 13:00 start_bot => 09:00 stop_bot => 15:30 if this case … program will be start t…

How to convert string to time and compare with current time?

ppr (Peter Preuss) November 17, 2022, 2:34pm 5

grafik

 Now.TimeOfDay >= Cdate("09:00").TimeOfDay And Now.TimeOfDay <= Cdate("15:30").TimeOfDay

As well agreed to use Timespan as we can reduce the code chars
grafik

Now.TimeOfDay >= Timespan.Parse("09:00") And Now.TimeOfDay <= Timespan.Parse("15:30")

2 Likes

Forum Engagement Daily Reports

Topic		Replies	Views
Comparing two strings and checking greater than 1hr Something Else activities , studio , question	3	404	March 1, 2023
I need to use "real time" for my project, how can I use it in uipath? Help studio , question	12	1161	February 18, 2019
String Value to Timespan Help selector , activities , question	1	2183	September 21, 2020
How to convert a String value from current row in excel to date time variable Studio studio , question , workflow_diff	3	834	December 12, 2022
Converting to DateTime from String Studio	4	859	September 26, 2020