In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

date difference

simran2003
7 - Meteor

I need to check whether start date is before end date or not?

how to do that in alteryx?

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @simran2003 ,

 

You can do that with the DateTimeDiff function. With that function, you can check also the difference between months, years, minutes, seconds, hours.. you only need to change the 3rh parameter.

fmvizcaino_0-1582785444128.png

 

Example attached.

Best,

Fernando Vizcaino

 

simran2003
7 - Meteor

I got your code.Thanks a lot.

Labels
Top Solution Authors