Start Free Trial

Alteryx Designer Desktop Discussions

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

calculate change in dates

pschlom
5 - Atom

How do I calculate a change in dates?  Which Icon do I utilize (new user)

 

3 REPLIES 3
geraldo
13 - Pulsar

@pschlom 

 

I didn't understand what kind of change you want in dates. if you can explain better

Silvia_Lau
6 - Meteoroid

@pschlom do you mean calculate the number of business days between two dates? 

Raj
16 - Nebula

To calculate a change in dates using Alteryx, you can utilize the DateTimeDiff() function, which calculates the difference between two dates or times in various units (e.g., days, months, years).

 

DateTimeDiff([Date1], [Date2], "days")

 

Raj_0-1685079715387.png

 

Labels
Top Solution Authors