Write workflow output based on timestamp

Question

Hi Team

I'm trying to write output to xlsx file based on timestamp.

I'm using Datetimeformat(Datetimenow(),"%Y-%m-%d-%H-%M-%S")

I do have 20 sheets to output in 1 single output xlsx file.

While loading the output to xlsx file, if we are @ in middle of output say @ 30 sec of minute, it is writing 1 output file and after it reached minute it is loading into 2nd output file with different minutes.

Is there any specific way to write all outputs at beginning timestamp or end of timestamp?

T

CBJohnson · Accepted Answer

Hi satishkurra,

Use the Date TIme Now tool to create the Time Stamp then append it where you need to to make a the file name. This will all you to use the same timestamp across all your files.