Date Interface with In-Database Filter Tool

[Abbie_Hill]

Hi

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

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

Thanks

[nicholas_marcheggiani · Accepted solution]

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.

[Abbie_Hill]

This works! 

Thank you for your help.