Insert date & time column
The Insert date & time column step adds a column with the current date and time, with customizable offset by days and timezones. The current date and time will be determined at the time the flow is run. This step can be useful for tasks like logging updated times.
Connect any data into this step. It'll give you the output data of a new "Current DateTime" column appended to your dataset where the current date and time is noted (based on when the flow is run).
By default, this step will have "Current DateTime" in the Column Name field, but you can customize this name to anything you prefer.
All date and time values created look like this format: 2019-09-18 12:33:09 (which is a format of YYYY-MM-DD hh:mm:ss). If you prefer a different format, connect a Format dates step right after this one to get the date values in your preferred way.
A date that is 0 days offset will be the current date and time. If you choose a positive value, it will be in the future, while a negative value will be in the past. If we add 1 to the Days Offset field, it shows us the date time stamp for this time tomorrow. If we add -1 to the Days Offset field, it'll show us the date time stamp for this time yesterday.
You can create multiple Add Date & Time Rules using a single step. Each rule will make a new column and the values of the column will be the same for every row. You might make multiple columns if you need the current date and time across different time zones or you want to have columns of varying offsets.