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
16 - Nebula
16 - Nebula

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
16 - Nebula
16 - Nebula

Fantastic news!

Labels