Hello,
I am trying to create a workflow that will dynamically select the column based on the prior month. I have set up a datetime formula to create a column containing the prior month, but I am having trouble with getting the dynamic select tool to remove all other columns except for the prior month column. As of today, 1/20/2022, the prior month column reads Dec, so I want only the Dec column to remain. I know I could use an interface tool to allow the user to select the specific column, but this is part of a large workflow that already requires more user input than I prefer using.
Thanks for the help.
Gelöst! Gehe zu Lösung.
Hi @GHaines
Maybe something like this? Takes the Currency column & the column based on the system date - 1 month.
[Name] = 'Currency'
OR [Name] = datetimeformat(datetimeadd(Datetimetoday(),-1,'month'),'%b')
That worked perfectly. Thanks for the help!