Compare Two Dates With Differing Formats

[AutomateWork (Robert Booth)]

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 a Var (I already have this done)
3.) Take Date From String and Compare to Todays Date and Allocate Difference in Days to a Var (This is where I need help)

Problem:

I am receiving this error message:

Assign : String was not recognized as a valid DateTime

I am using this code in an ‘Assign’ activity to convert string to DateTime which is popping up error:

DateTime.ParseExact(vDueDate_String, “dd-MM-yyyy”, CultureInfo.InvariantCulture)

Potential Reasons:

1.) The Date String I am passing into this (‘vDueDate_String’) is in a ‘MM/dd’yy’ format…this is the format that is in the string that I am parsing out.

Thus, do I need to change the format of this var to the ‘dd-MM’yyyy’ format before putting into the ‘Compare Date’ activity?

Any and all help would be much appreciated.

[aksh1yadav (AKSHAY YADAV)]

@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?

Get difference between two dates?

Hey @prajakta well this is due to the date format you are passing. on your system it might be like MM/dd/yyyy(10/12/2017) better to check date format on your system write line Now.Date.Tostring and check. and from your excel you are getting like this 12-10-2017 i.e so format mismatching so you are getting wrong or negative result. if you will do like this it will return you 0. Convert.ToString((Now.Date - Now.Date).TotalDays) // write line it. Convert.ToString((Convert.ToDateTime(“10/…

Regards…!!
Aksh

[AutomateWork (Robert Booth)]

Thanks so much!

I apologize for repost question but I genuinely thought inquiry was different.

[aksh1yadav (AKSHAY YADAV)]

Its ok pal @AutomateWork

Better to search with keywords you will get more accuracy 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

[AutomateWork (Robert Booth)]

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 as well.

IS there a workaround for this?

[aksh1yadav (AKSHAY YADAV)]

@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

to check date format on your system write line Now.Date.Tostring and check.

Use TotalDays instead of Days.

like this:

Convert.ToString((Convert.ToDateTime(“10/12/2017”)- Convert.ToDateTime(“10/12/2016”)).TotalDays) //365

Or if you want in Year Month things then you can perform some operations. Let me know…

Regards,!!
Aksh

[AutomateWork (Robert Booth)]

Worked like a charm!

Thanks again.