G'day,
I want to generate a Datetime stamp to add to a filename, which is then used for the output field in a batch macro. I've tried with formula tool, and some other options - trimming down to the hours etc, but using something like --> [Filename] + " " +DateTimeNow().
When i do it this way, the output changes with the time and splits the output files which is not ideal.
What I'd like to do is create one timestamp which is attached to every record with the filename, just not sure what path to take doing this - MultiRow formula is where I'm leaning but im a bit stuck on what logic to use.
Cheers!