Creating date difference and create bins

[sriniprad08]

Hi Team,

I have a below situation

1) Find the difference between two dates and calculate the days.

2) Create bins based on the below criteria.

Please let me know how to go about it.

Id	Date 1	Date 2
1	12/13/2002	12/30/2021
2	1/15/2003	12/20/2002
3	4/8/2003	12/31/2003
2	7/2/2003	12/31/2020
4	8/6/2003	9/30/2003
4	8/6/2003	9/30/2004
4	8/6/2003	1/30/2004
4	8/6/2003	2/27/2004
4	8/6/2003	2/27/2004
4	8/6/2003	11/30/2003
4	8/6/2003	10/31/2003
5	8/6/2003	1/30/2004
5	8/6/2003	11/30/2003
	8/6/2003	10/31/2003

[sriniprad08]

[atcodedog05]

Hi 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05 · Accepted solution]

Hi 

Here is the completed workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[sriniprad08]

hi @atcodedog05 

Great thank you so much 🙂

[atcodedog05]

Happy to help 🙂 @sriniprad08 

Cheers and Happy Analyzing 😀

[sriniprad08]

Hi @atcodedog05 ,

Thanks for the solution. However i am getting warnings and it's not giving me number of days and also giving me same bins for all the dates. It's the same data which i shared yesterday. Can you please let me know . Please find attached the warnings, Thanks

[atcodedog05]

Hi @sriniprad08 

Your date format has changed hence its throwing a parse error.

[atcodedog05 · Accepted solution]

Hi @sriniprad08 

Since its already in dates you can just use the formula.

DateTimeDiff([Date 2],[Date 1],"days")

[sriniprad08]

Hi @atcodedog05 

thank you so much 🙂

cheers,