In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Community Gallery

Create, download, and share user-built tools and workflows.
Looking for Alteryx built Add-Ons?

Easily shop verified, supported, and secure Partner and Alteryx built Add-Ons on Marketplace.

LEARN MORE
Comments
RWvanLeeuwen
11 - Bolide

Description: using a [start date], count the number of workdays (not Sat/Sun) up to but not including the [end date], and have an option to use a [holiday date] field to have an additional set of dates that are to be excluded.

Shawlenemao62
5 - Atom

Hi Team, I'm getting a parse error with the formula below.  Please help:

 

DateTimeAdd(datetimetoday(), - [Stage Start Date], "days")

 

Error received: "Parse Error at char(30): Type mismatch. String provided where number is required. (Expression #1)"