Attempting to set dynamic variables in a chain, and need to reference the value of one variable from the other. This is the first step in my chain.
EffectiveDate: The current datetime, minus 1 month
FilePath: A file name that contains the value of EffectiveDate, transformed. For example: "SomeFileName Sept-2022.csv".
I receive no errors when I save the "Set Dynamic Chain Variable" event as shown in the screen shot below. But the result is showing that EffectiveDate does not have a value when the FilePath variable is being set during the first execution run. The second time I execute it, the EffectiveDate value is set using a cached value from the previous run.
How can I reference one dynamic variable from another one in the same event?