How does DateTimeDiff function work exactly?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I'm looking for some information on the DateTimeDiff function - I was looking at help and around here, but didn't find all the answers.
1. Does it matter in what order I put the dt1 and dt2 parameters?
2. If the answer to 1. is no, how can I check which date is the earlier one? I'm used to being able to use comparators (<, > and so on) on dates in different programs, I think this didn't work when I tried it in Alteryx (IIRC I got the 'incorrect data type' error).
Thanks,
Michal
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
1. The order matters only in that it gives you a positive or negative answer depending which way round they are. If you just want to know the difference you could warp it with abs()
abs(DateTimeDiff([Date1],[Date2],"days"))
2. I think < > do work on dates
[Date1]<[Date2]
https://www.linkedin.com/in/adriley/
