filtering on dates

[ntudev]

I have 2 dates 2022-04-28 and 2022-05-26 i want a filter that only picks up the higher date and another formula that picks up the lower date. I have been manually inputting a filter that picks up the dates per below, in the future its going to be an issue if i have to manually do this. please help!

ToDate([As of MMDDYYYY]) = "2022-05-26"

ToDate([As of MMDDYYYY]) = "2022-04-28"

[stvnhdmpa]

@ntudev Are you trying to get the highest and lowest date out of multiple records in a column or are you trying to get the highest and lowest date out of two columns in one record?  

[ntudev]

basically the data splits into 2 groups, 1 with 5.26 and 1 with 4.28?

[stvnhdmpa]

@ntudev Would something like the attached work?

[ntudev]

so then i have to put another filter to pick up only the min or max? because its showing the max date1 and min date 1 for some reason. I just need it to pick up all information tied to Max or Min date and put it in a separate group.

[stvnhdmpa]

@ntudev yes.  the first step is to determine what the filter criteria should be, then in the example I provided I showed how you can append the max and min back into the data and then filter it.  

[ntudev]

thank you! this works but its really slow it takes about 4 minutes to load. any way i can speed this up?

[stvnhdmpa]

@ntudev What's taking the time?  If you turn on performance profiling, this will give you an idea of which tools are taking the longest to run.  

Based on the little I've picked up, if you only have two dates in your data set, Max and Min, do you need multiple filters?  If you filter the Max through the True anchor, then by default the Min value will be through the false.  Also, I'm not quite follow what you are doing with your joins. 

[ntudev]

you definitely right i can just use true and false to separate the 2 dates. It takes me about 4.30m to load the data, its just slowing down when it gets to two joins for some reason.

how do you get to workflow configuration?

[stvnhdmpa]

Click in the canvas (white space) and you will find the runtime option under the configuration.

Why do you need the joins?  The filter is only filtering the dates, so all the columns already exist, so you shouldn't need to join anything back.