Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter Directory on User Date Input

Astrology1901
6 - Meteoroid

I'd like to filter a directory based on a user input date.  I'm getting a type mismatch error from the Action tool to the Filter tool.

 

I've tried changing the Filter tool as follows:

 

ToDate([CreationTime]) IN (1)

 

Then tried to force the Action tool connection (1) to a date

 

[CreationTime] IN ToDate((1))

 

Then both

 

ToDate([CreationTime]) IN ToDate((1))

 

 

Alteryx Date Filtering.png

 

 

Nothing I've tried works.  I'm sure I'm just overlooking something simple...Thank you!

3 REPLIES 3
alexnajm
18 - Pollux
18 - Pollux

I think you need ToDate([Creation Time) = [#1], and connect the Date tool directly to the Q anchor of the Filter tool!

Astrology1901
6 - Meteoroid

Alteryx Date Filtering.png

You sir, are the man!  Just had to force the #1 parameter to a date as well: ToDate([CreationTime]) = todate([#1]).

 

Thank you!

alexnajm
18 - Pollux
18 - Pollux

Fantastic news!

Labels
Top Solution Authors