Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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
‎05-15-2020 03:06 PM

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

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor
‎05-15-2020 03:25 PM

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

DateTimeDiff_15052020.yxmd
Reply
0 Likes
mlozovskaya
8 - Asteroid
‎05-15-2020 03:29 PM

@JosephSerpis Thanks so much! it works!

Reply
register for inspire
designer new user guide
Labels
Top Solution Authors
View All