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"

[ntudev]

if i dont join to the original then i only get the below, i need to have other information such as balances and company names combined too.

[stvnhdmpa]

@ntudev Make sure in your you aren't unchecking anything you need downstream in your append tool.