Alteryx Formula Tool - DateTime Formula Demonstration

Download a Free Trial of Alteryx! tinyurl.com/y5alktlu
Apply DateTime functions with the Formula tool, which creates a new column, or updates a column, using one or more expressions to perform a variety of calculations and operations. A DateTime function performs an action or calculation on a date and time value. Use a DateTime function to add or subtract intervals, find the current date, find the first or last day of the month, extract a component of a DateTime value, or convert a value to a different format.
Alteryx uses the ISO format yyyy-mm-dd HH:MM:SS to represent dates and times. If a DateTime value is not in this format, Alteryx reads it as a string. To convert a column for use and manipulation in the DateTime format, use the DateTimeParse function in the expression editor or the DateTime Tool.
***********************************************************************************************
What is Alteryx?
Revolutionizing business through data science and analytics, Alteryx offers an end-to-end analytics platform that empowers organizations to break data barriers, deliver insights, and experience the thrill of getting to the answer faster. Hundreds of thousands of users all over the world rely on Alteryx daily to deliver real business results.
***********************************************************************************************
AB Data Consulting understands data challenges and equips teams with the knowledge, tools and confidence to overcome those obstacles and lead a digital transformation. Automation enables you to provide detailed process documentation, remove any key person risk, and transition away from ‘unwritten rules’ in data processing.
www.abdataconsulting.com/
Alteryx One Tool at a Time is a video series produced by AB Data Consulting for educational purposes and for use by anyone interested in learning Alteryx. To request additional tool videos, email [e-mail].

[@mariabeltzer9312]

Super helpful!! Thank you so much.

[@blighali7468]

A great way my teacher I have a project about it

[@jikkujosephmathew2928]

How to remove weekends and Holidays in between the selected period?