Sharing the same date formula with 2 Formula tools

[Apcvirgo1]

I need to use the same date formula in 2 places in a workflow. The first feeds a query and the second is for the title of the output file. Is it possible to share the results from the first formula tool in the second?

[atcodedog05]

Hi @Apcvirgo1 

You can use append tool to bring forward the date and append it.

[atcodedog05]

Hi @Apcvirgo1 

You can do something this

Workflow:

Hope this helps : )

[Apcvirgo1]

Thank you, but the append tool doesn't let me add the formula to create the output file name. The date is needed for a monthly file - "\\WSOMHR06382v1\MISIRODept\MIS\PROJECTS2021\DA20210269 Sight and Referral Fee Report\Workflow\Test Q2 output "+[Month2]+".xlsx|||Sheet1"

[atcodedog05]

_

[atcodedog05]

Hi @Apcvirgo1 

You can calculate output path in the before formula tool itself and append later 🙂