Hi, I realize this question has come up multiple times but I have yet been able to solve it as my situation seems to be a little different than the previous posts. Goal: 1.) Extract String from Webpage that contains a Date (I already have this done) 2.) Parse out Date From String and Allocate to…

[image] AutomateWork: However, when I ran the automation it only gave me back 5 Days as difference. This might be the format…of datetime at your system :slight_smile: to check date format on your system write line Now.Date.Tostring and check. Use TotalDays instead of Days. like this: Conv…

[image] AutomateWork: Take Date From String and Compare to Todays Date and Allocate Difference in Days to a Var (This is where I need help) Hey @AutomateWork Have you gone through with this thread? [image] Get difference between two dates? Help Hey @prajakta well…

Thanks so much! I apologize for repost question but I genuinely thought inquiry was different.

Its ok pal @AutomateWork Better to search with keywords :slight_smile: you will get more accuracy :slight_smile: but nevermind i also remember this because i have posted for the same otherwise it is difficult sometime to know the posts which already exists :slight_smile:

Thanks for advice! Actually, the solution does work but not as intended ;/ So this particular use case…the Due Date was 11/1/10 (Thus a long time ago) However, when I ran the automation it only gave me back 5 Days as difference. This is because it is only taking into account the days, not years …

Worked like a charm! Thanks again.

Compare Two Dates With Differing Formats

Help

aksh1yadav (AKSHAY YADAV) November 6, 2017, 5:32pm 2

Hey @AutomateWork

Have you gone through with this thread?

Regards…!!
Aksh

Topic		Replies	Views
Date Comparison Error Help	6	1957	June 10, 2019
Compare two dates with different formats(string: "dd.MM.yyyy" and generic value "dd/MM/yyyy hh:mm:ss") Studio string , question , data_manipulation	3	4669	April 29, 2020
String was not recognized as Valid DateTime RPA Discussions general	5	982	February 23, 2022
Date difference showing error Studio studio , question , workflow_diff	15	672	July 1, 2023
Unable to Compare dates of different format Community question , community	4	1024	June 14, 2021

Compare Two Dates With Differing Formats

Related topics