Dynamically change date in SQL Query

I'm creating a workflow that shows top 50 customer revenues by the past six months. How can i dynamically change the query to filter the dates between the current month and six months earlier? I want this flow to be completely automatic without me having to change the parameters of the months every time I run it. My dates are set up as yyyymm. I am using a teradata input.

Developer

Gallery

Developer Tools

Designer Cloud

Dynamic Processing

Accepted answers

alexnajm

Something like this should work! The query can now be input in the Dynamic Input tool and the "Modify SQL Query" option can replace the date values you'd have in there

Dynamically change date in SQL Query.yxmd

All comments

alexnajm

Something like this should work! The query can now be input in the Dynamic Input tool and the "Modify SQL Query" option can replace the date values you'd have in there

Dynamically change date in SQL Query.yxmd

gautiergodard

Agreed with @alexnajm - either of the highlighted options below should work for you:

If one doesnt, try the other, I've experienced mixed results depending on the use case.

alexnajm

Agreed @gautiergodard!

apathetichell

As always I'm going with dynamic input in-db and editing the where clause in a formula tool.

not to say the other answers are wrong but personal preferences and if you are doing the query on server or on your own system...

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703