Add new field with Date

hello experts！

I would like to change filed with the update period name, for example, in August, I want to change the name with "July 2022", and once I am in September, and when I run the workflow, I want to change the column name as "August 2022". The month and year should update month over month. Please help advise. Thanks!

Preparation

Accepted answers

Amol_Telore

Hey @wendyzjy

You can use dynamic rename tool to rename field name using formula as per your needs. Hope this solves your concern.

New Workflow2.yxmd

All comments

Qiu

@wendyzjy
We can use the DateTimeNow function to get the current date, then do some calculation and formatting.

0829-wendyzjy.yxmd

wendyzjy

This could be a solution, but I actually would like to change the column name only but not the field values. Should I should Multi-Row Tool?

Amol_Telore

Hey @wendyzjy

You can use dynamic rename tool to rename field name using formula as per your needs. Hope this solves your concern.

New Workflow2.yxmd

liwagab

using datetimenow() function in the formula tool should complete your requirement

output would be dynamic based on the month you are running the workflow.

wendyzjy

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703