Trouble with Dynamically Selecting Columns

[GHaines]

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.

[Luke_C · Accepted solution]

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')

[GHaines]

That worked perfectly. Thanks for the help!