I have a workflow that has a lot of branches. All these branches write to the same excel, but in different tabs.
The name of the excel file consists of the date but I would like to add the time as well.
How can I add the time to the end of each branch but calculate it at the beginning of the workflow? If I calculate it at the end of each branch then the time could differ between branches.
I'd rather not calculate it at the beginning and add it with an append fields at the end of each branch. Is there a better, easier way?
Something like a constant where I can refer to?
Solved! Go to Solution.
You can create it at the very beginning of the workflow and then with a Formula tool add it to the path name of each of the branches
@OTrieger the different branches do not have the same starting point + its a very big flow with lots of summarizes etc. I'd rather not need to adjust the whole flow to get the time field downstream.
@leonhekkert you may utilize this datetime function?
Then why you do not want to appended it to each of the branches?
Well, that would be my solution, but I was wondering if there was another easier way. DateTimeStart() seems to be just that! :)