Formula to generate datetime and autofill every row with the same value.

[MFish]

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!

[grazitti_sapna]

Hi @MFish , will it be possible for you to share a sample of expected output also what are you trying in the multi row formula so that we can try to debug this issue?

Just to clarify when you will use datetimenow function it will generate different current time every time you run the workflow.

Thanks.

[MFish]

Expected output would be;

FileName1 YYYY/MM/DD HH:MM

I'm able to generate this format, but because the time can change very rarely on the hour, and more commonly on the minutes - it has the potential to split my CSV output. 

I haven't been able to get a working formula going in the multi-row formula tool yet, I'm not sure if i need to first generate a filename+timestamp in the formula tool, then fill the first value down for all row via the multi-row formula tool?

And yes your clarification is correct! 

Thanks

[vizAlter]

@MFish — Special character / and : in the file name? 🤔

[grazitti_sapna · Accepted solution]

Hi @MFish, if the first question can be modified into something like Test 2020-11-04 10.30 then it is working perfectly.

For multi row query

Thanks.

[MFish]

Absolute legends, i actually figured out another way to do it - but thanks so much for going to the effort!

[grazitti_sapna]

@MFish , you can also post the solution that you worked on maybe it will help us and others in other cases. 🙂

Thanks.