Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
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

Date Difference

Hiteshp
7 - Meteor
‎02-05-2025 03:10 PM

How do i get the count between 2 dates. I have the following data available:

 

Start DateEnd Date
1/7/20251/7/2025
2/11/20252/11/2025
3/10/20253/11/2025

 

  Need the output in the following order:

 

Start DateEnd DateCount
1/7/20251/7/20251
2/11/20252/11/20251
3/10/20253/11/20252

 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
CoG
14 - Magnetar
‎02-05-2025 03:17 PM

DateTimeDiff([End Date], [Start Date], "Day") + 1

Reply
Qiu
21 - Polaris
21 - Polaris
‎02-05-2025 04:26 PM

@Hiteshp 
Just add to CoG advice, we need 2 DateTime tools to convert the Date in String to DateTime format 

0206-Hiteshp.png

0206-Hiteshp.yxmd
Reply
0 Likes
inspire ask me anything
inspire session catalog
Labels
Top Solution Authors
View All