Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
Alteryx Designer Desktop Knowledge Base
Definitive answers from Designer Desktop experts.How To: Create a new date field based on a Formula
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.
Expression:
DateTimeAdd([Date], -1, 'month')
null
