Adding today's date as a column in excel

[deaser59 (Chris Dease)]

i’m building a data table to collect some data and i’d like for one of the columns to be the current date. is there an activity to accomplish that in studio? here’s an example of my spreadsheet:

i already have the EmpId and RequestId set up but i need to add the date.

Regards,
Deaser59

[SenzoD (Senzo Dlomo)]

@deaser59, yes there is an activity, refer to below: and to get a hint on how it works, download the example they provided.

Add Data Column

[mzahid (Zahid)]

@deaser59

If you need Date column to be just only date (5/23/2020) use date.Now.ToShortDateString in assign activity.
You can use date.Now.ToString if you need time and date together(5/23/2020 1:00:11 AM) in assign activity.

In case the workflow is not clearly visible