Adding today's date as a column in excel

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.


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



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


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.