Write workflow output based on timestamp

[satishkurra]

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

[jrgo]

Depending on the version of Designer, you can use the date function DATETIMESTART(). If you don't see that function, you'll have to append a single row to your data to ensure they all have the same datetime stamp.

Datetimeformat(DateTimeStart(),"%Y-%m-%d-%H-%M-%S")

[CBJohnson · Accepted solution]

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.