Alteryx Designer Desktop Discussions

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

Date Difference

Hiteshp
7 - Meteor

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

 

2 REPLIES 2
CoG
14 - Magnetar

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

Qiu
21 - Polaris
21 - Polaris

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

0206-Hiteshp.png

Labels
Top Solution Authors