Dynamic Filter based on date from another output

Hi,

So i have some data where i need a filter to only include dates that occur after the beginning of the month. Basically i have an output that gives me a date and i need to filter my data from the beginning of that month.

So the above is my data, the final field is the one i need to filter. Below is the output where it gives me a data, but i need to only keep values that are greater than or equal to the beginning of June 2020.

Not sure if this is possible to automate but it would help immensely from having to do a manual filter each time i run my workflow. in the above scenario i would only retain the first 2 records as the 3 record occurs in March.

I have attached both data inputs into a workflow below.

Thanks!

EHS Filter.yxmd

Tips and Tricks

Date Time

Dynamic Processing

Accepted answers

krishnagandhi

Thanks that spurred a solution in my head as follows in case anyone else needs it:

EHS Filter.yxmd

All comments

Blake

Hey @krishnagandhi - you could use a custom filter with the following expression to only get dates that started at the beginning of the current month : [Min_WorkDate] > DateTimeFirstOfMonth()

Do you need to have records from the beginning of the prior month, as your example shows? If so, you could use the following : [Min_WorkDate] > DateTimeAdd(DateTimeFirstOfMonth(), -1, "months")

See the attached for an example of the filter.

EHS Filter.yxmd

krishnagandhi

This doesn't quite work because the date is dependent on the output of in Mode CCC Workdate. In this instance it is June so i need anything after June 1st but i also have historical runs so that is why this solution will not always work.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703