SOLVED
date difference
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
simran2003
7 - Meteor
‎02-26-2020
10:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need to check whether start date is before end date or not?
how to do that in alteryx?
Solved! Go to Solution.
Labels:
- Labels:
- Best Practices
2 REPLIES 2
fmvizcaino
17 - Castor
‎02-26-2020
10:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Example attached.
Best,
Fernando Vizcaino
‎02-26-2020
10:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I got your code.Thanks a lot.