SOLVED
Date Difference in Alteryx.
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
rohit782192
11 - Bolide
‎01-25-2020
11:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Labels:
- Labels:
- Alias Manager
- Amazon S3
- Apps
- Batch Macro
- Behavior Analysis
- Best Practices
- Bug
- Calgary
- Datasets
- Date Time
- Demographic Analysis
- Developer
- Developer Tools
- Documentation
- Download
- Dynamic Processing
- Error Message
- Events
- Expression
- MongoDB
- Optimization
- Parse
- Power BI
- Publish
- Python
- Qlik
- R Tool
- Regex
- Reporting
- Run Command
- Salesforce
- Scheduler
- Server
- Settings
- Spatial Analysis
- Time Series
- Tips and Tricks
- Transformation
- Workflow
3 REPLIES 3
RolandSchubert
16 - Nebula
‎01-25-2020
11:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @rohit782192 ,
there is a function DATETIMEDIFF to calculate the difference between two dates.
DateTimeDiff([Field1],[Field2],'days')
where 'days' can be replaced by the unit you need (e.g. 'month').
Best,
Roland
‎01-25-2020
11:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I Tried it is working for me.
okaychill
5 - Atom
‎03-02-2023
09:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I tried it is giving null for some values not sure why though