I have the following query adding into the dynamic input
Select *
From Table1 A
Where A.Date_1 >= CAST( '2020-01-01' as DATE) - 10 days
and A.Date_1 <= '2020-04-01'
Now i am not able to replace the first WHERE Clause date highlighted above that has to be replaced with another date column coming from the source.
Any help is appreciated.
Can you post a screen shot of how you're configuring the Dynamic Input tool?