In DB Dynamic Date filter

[forifi1]

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.

[christine_assaad]

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!

[SeanAdams]

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