Copy historical data and append today's date

Hi all,

I'm running a workflow that get's historical data, copies it and appends today's date to Run Date column as shown below, but am unable to make this workflow work. My data has the following format, any one know I can make this work?

Item	Value	Run Date
A	10	10/05/2021
A	10	11/05/2021
A	10	12/05/2021

Developer Tools

Accepted answers

All comments

mceleavey

Hi @mtuwanax ,

You need a formula tool to either create a new column, or replace Run Date with datetimetoday()

TheOC

hey @mtuwanax

Just to check, you just need todays date appending as a field to rundate?

I've done that in the attached workflow, but only where rundate is null, so that it doesn't replace the current values.

IIF(IsNull([Run Date]), DateTimeFormat(DateTimeNow(),"%d/%m/%Y"), [Run Date])

The key is to use datetimenow() to get the current date, and then format this as dd/mm/yy

Hope this helps!
TheOC

mtuwanax.yxmd

mtuwanax

Hi @TheOC @mceleavey

Thank you for your responses.

I realized that my question was not very clear. In my workflow, I ran a daily report to get the current month's data and append today's date as the run time to the excel workbook, which i've been able to achieve. My challenge is copy previous months' data and appending it to the workbook and adding the today's date as the run time to the historical data.

Hope the question is clearer now. I've built this workflow, but somehow it appends an excessive number of the historical data.

Copy Historical data.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703