Free Trial

Alteryx Designer Desktop Discussions

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

Number of days count

mlozovskaya
8 - Asteroid

What would be the best option in Alteryx to simulate excel formula [Date1]-[Date2] to calculate number of days between 2 values?

Example:

Date 1 12/22/2019

Date 2 10/30/2019

Result  53

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @mlozovskaya I mocked up a workflow that produces yours output. Let me know what you think?

mlozovskaya
8 - Asteroid

@JosephSerpis Thanks so much! it works!

Labels
Top Solution Authors