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))
Nothing I've tried works. I'm sure I'm just overlooking something simple...Thank you!
Solved! Go to Solution.
I think you need ToDate([Creation Time) = [#1], and connect the Date tool directly to the Q anchor of the Filter tool!
You sir, are the man! Just had to force the #1 parameter to a date as well: ToDate([CreationTime]) = todate([#1]).
Thank you!
Fantastic news!