Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Dates between two dates within one month

MKM
7 - Meteor

Hi all, 

 

Couldn't find this answer but seems doable

 

I want to count the amount of days within one month between two dates. For example, if the start date is 8/1/2017 and the end date is 10/31/2017,  I want to return 31 because there are 31 days in August and when I run it again in September, I'd want it to return 30.

 

I tried using DATETIMEDIFF but that didn't include the part of days within a certain month. Is that doable?

 

Thanks!

10 REPLIES 10
rohanonline
10 - Fireball

Hi @syatham1

You can use the tool - "Generate Rows" to do what you are aiming for. You don't need to create a macro for this.

Labels
Top Solution Authors