Alteryx designer Discussions

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

Date Interface with In-Database Filter Tool

Highlighted
6 - Meteoroid

Hi

 

I'm trying to use the Date Interface tool with the In-database Filter tool but get this error

 

DateTime2.PNG

 

Dates in the table are DateTime2. Is the Date Interface tool only compatible with DateTime? Am I doing something wrong?

 

Thanks

Highlighted
6 - Meteoroid

just a thought. Try putting single quotes around your date so that the output is '2018-11-01'

you can try to do this in the action tool with a formula "'"+[#1]+"'"

 

Let me know if that works.

Highlighted
6 - Meteoroid

This works! 

 

Thank you for your help.

 

 

Labels