User-Friendly Date Selection

Coriel-11

Hi everyone,

I'm trying to make life easier for less-technical colleagues  who need to run workflows.

Typically our workflows will revolve around a certain date. The report will be pulled on an ad-hoc basis and the person will be after all the records since last time it ran (which was similarly ad-hoc.

What I'm trying to do is have an easy way for them to be able to enter that date without having to dive into the code in the Connect IN-DB tool, or find it in a filter. I want a simple way to be able to enter it into a box so it becomes a constant which other parts of the workflow can then draw on.

I've looked at the date-interface tool, but that seems to be for something else .I've also looked at defining constants by right-clicking on the workflow, but can't get them to work as dates (in say and in-database filter).

I can't be the only one after something like this, but can't work out how to do it. Please could some of you give me some ideas?

Thanks,

Matt

echuong1

Try this - I used a standard input, but the same should work in an in-DB input as well.

SELECT FIRST_NAME as "First Name",
LAST_NAME as "Surname",
DATE_ADDED as "Constituent Date Added"
FROM "Demo Datasets"."dbo"."Records"
where DATE_ADDED >= '2020-03-10'

New Workflow4.yxwz