This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The highly anticipated Alteryx Community tradition is back! We hope you'll join us!
- edited on
How to: Create a new date field based on a formula?
For example, let's say I want to calculate one month prior to an existing date. i.e. 6/1/15, month prior is 5/1/15.
To do this, I'll add a Formula tool to the canvas, connect it to your data stream, and use the DateTimeAdd() function.
DateTimeAdd([Date], -1, 'month')