Need to calculate the days differs

Help Activities
, , , , , , ,
1

1/1/2022-3/20/2022

In above days whole January,February and 20 days of March is covered

So my output should be 31 for January
28 for February and 20 for March how to implement in code

4

We use the strings for conversion to DateTimes and can do then the calculation
grafik
(CDate("3/20/2022")-CDate("1/1/2022")).Days

for a month split output a construction via loop could be the first start for the solution approach

5

Can you please explain briefly about the month split

6

sure, let us know which detail output format / datatype you are looking for

7

Output format should be as integer

8

Any solution for this

9

Hello @sruthesanju

You can try with Modify Date activity.

Thanks

10

I need to find the number of days between two days
1/1/2022-3/20/2022

Need to split the days as since it has full January so output should be as 31
and February so output ebe 28
And it has 20 days of March so output should be 20

My output:31 28 20

11

Hi @sruthesanju

I have responded to your questions in the below post created by you.
Please let me know if you have different requirement.

How to count number of dates between two dates

12

That is for same month
If I get different month the I need to split based on the months

13

I have created a workflow to perform splitting of the month

Output 1:

image

Output 2:

image
image460×559 6.82 KB

Date_Calculator_2.xaml (14.4 KB)

If you have any issues with the attached workflow. then please share the error screenshot.

image
image1183×2186 148 KB

Thanks
John

14

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