Hello all,
Here's what I am trying to do. I have several columns (consider 2019 as 2018):
And I want to delete columns based on the current month. Today being 9 August 2018, the workflow would ideally delete the columns prior to that date, meaning 2018-03-01, 2018-04-01, 2018-05-01, 2018-06-01 and 2018-07-01.
Is it easily possible ? If the only solution is a complex one, I would gladly use it as well.
Thanks
Solved! Go to Solution.
Use the Dynamic Select tool set to Select Via Formula with the below formula:
Left(Replace([Name],"-",""),6)>=Left(Replace(DateTimeToday(),"-",""),6)
Hello,
You could use the dynamic select to do this in a single tool. I prefer to use a couple of tools as the logic becomes more transparent. I would transpose all the columns and use a custom filter tool, to filter out any dates greater than today's date, then cross tab back into the original format. V2018.2 workflow attached.
Thank you all for your answers, gave me creative ideas !
That's a clean way to do this. Thank you so much 🙂