Create new column with Date

[shivanand612]

Hi All,

i am having an issue with one of my table and I wanted to create a new columns with Date (this is dynamic) using below table.

Record ID	Monthly	Quarterly	Yearly
1	OCT 21	4Q 21	FY21
2	12344	32123	123123
3	12312	23243	745646
4	54533	23423	644234
5	12345	43455	54543

I am looking for below table by using the above one.

Record ID	Monthly	Quarterly	Yearly	Month	Quarter	Year
1	OCT 21	4Q 21	FY 21	OCT 21	4Q-21	FY21
2	12344	32123	123123	OCT 21	4Q 21	FY21
3	12312	23243	745646	OCT 21	4Q 21	FY21
4	54533	23423	644234	OCT 21	4Q 21	FY21
5	12345	43455	54543	OCT 21	4Q 21	FY21

Regards,

Shiva

[atcodedog05 · Accepted solution]

Hi @shivanand612 

Here is how you can do it.

Workflow:

Hope this helps : )

[shivanand612]

This was a super fast response 🙂

Thank you  

[atcodedog05]

Happy to help : ) @shivanand612 

Cheers and have a nice day!