I need a way to filter on current date In DB, wither in the Data Input SQL, or via an In DB Filter on my canvas. I can get the dynamic filter to work properly when not in In DB, but the same expression does not work In DB. Appreciate any help.
Hi @forifi1
INDB requires the use of SQL syntax.
As an example, what you could get using "datetimetoday()" outside of INDB is equivalent to "cast(GETDATE()as date)" INDB. Hope this helps. Cheers!
Hey @forifi1
@christine_assaad 's method is most direct - The other alternative you have is wrap this in a batch macro (by dragging on a control parameter) and then you can use an Action tool to dynamically change filters or SQL queries.
You can learn more about batch macros here: https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Batch-Macro/ta-p/657923