Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

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
17 - Castor
17 - Castor

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
17 - Castor
17 - Castor

Fantastic news!

Labels