Possible to the use "Date Interface Tool" in Coordination with the "Connect In-DB" Tool?

[TerenceLebegern]

Hi

I run a workflow once every month to pull records for the past 12 months.  Currently, I need to manually key in the new dates in the "Table or Query" box of the "Connect In-DB" tool.  Is there a way to use the "Date Interface Tool" to select dates that then update the code in the "Table or Query" box?

Thanks,

Terence

[bpatel]

@TerenceLebegern ,

since i don't know what your query looks like i just mocked up something simple. in your action tool select the query and at the bottom of the configuration window you will get the option to replace a string. in that box delete everything except the date that you want updated. i would also make sure the date is the proper Alteryx format (yyyy-mm-dd).

i hope this helps

[TerenceLebegern]

The query is as follows:

SELECT Statekey, VIN, ESN, Reportable, EventId, LifSTATE, actualsalescode, corpid, scr_modelyear, scr_make, scr_model, shippeddate, shippedrecdate, Shippedstatusdate, ShippedAssumedFlag, CustomerTypeCD, newrecvdate, newrecvrecdate, newrecvstatusdate, newrecvassumedflag, newsolddate, newsoldrecdate, newsoldstatusdate, newsoldassumedflag, usedsolddate, usedsoldrecdate, usedsoldstatusdate, UsedSoldAssumedFlag, Head_Unit_Type
FROM DP_VEDW_BIZ_SPO.v_StateLifDimension
where changedateend > date and corpid = ANY ( '2524') and ShippedrecDate between '2019-06-01' and '2020-07-07' and vin not in (select commissionableelementid from dp_vedw_cds.payment_history where corpid = ANY ( '2524') and onetimepaymenttype = 'Hardware Subsidy');

The only changes to the query every month are the dates.  I was imagining something like I currently do in Teradata, which is to say I replace the dates with a "?", and pop up boxes request input for the dates.  Is something like that possible?

[bpatel · Accepted solution]

@TerenceLebegern ,

yes that is possible, i attached the sample workflow for you to replicate. instead of having "?" you would just keep a sample date that would get replaced with the new date