ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start 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
19 - Altair
19 - Altair

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
19 - Altair
19 - Altair

Fantastic news!

Labels
Top Solution Authors