Alteryx Designer Desktop Discussions

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

Hi,

I have a table with a period begin date and end date

I need a way to measure how many of those days are in between two fixed dates.

For example how many days are between 01.01.2021 and 10.01.2021

The answer in this case, by rows, would be 10, 10, 0.

The period-end/start can have multiple years in between and the same goes for the fixed dates.

2 REPLIES 2

Use the DateTimeDiff function - it takes 3 arguments, the start date, the end date, and the units you want to count (ie days, months, etc,)

@vanjak
Just a sample.

Counting days between dates