Difference between dates which is in 20200717 format

Help Studio
1

Hello. Please help me with getting date differences. Date is in this format “20200717” that is “yyyymmdd”. I need to get the difference of “20200717” - Today’s date. Output must be in days. Please help.

Thank you

2

@Pavan_Patke
have a look here:

(DateTime.ParseExact("20200717","yyyyMMdd", CultureInfo.InvariantCulture) - Now).Days

grafik
grafik742×41 2 KB

with following:
Math.Abs((DateTime.ParseExact("20200717","yyyyMMdd", CultureInfo.InvariantCulture) - Now).Days)

grafik
grafik736×45 2.14 KB

the day difference in Absolut (no negative value for a minus difference) is retrieved

3

Hi @Pavan_Patke

(DateTime.ParseExact(DateTime.Now.ToString(“yyyyMMdd”), “yyyyMMdd”, System.Globalization.CultureInfo.InvariantCulture)-DateTime.ParseExact(“20200717”, “yyyyMMdd”, System.Globalization.CultureInfo.InvariantCulture)).TotalDays

Output :-
image

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

4

Thank you guys. I’ll give a try and I’ll get back to you. :blush:

5

Hello Pratik. May I request you to share the .xaml file for this?

6

Hi @Pavan_Patke

Sure. Below is the Workflow for the same.

MainPratik.xaml (7.2 KB)

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

8

HI @Pavan_Patke

Delete the post in which you have put your personal details. As it is not allowed to post personal details anywhere.

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

9

Sure. Thank you. I’ll do it right away.

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.