Need to automate date column.

Question

I want to automate yellow highlighted cell of date using formula in Alteryx. Date is column header.

This will be updated every quarter eg: When "31/03/2023" change all other dates will automatically changed as per formula.

Also, These dates column need to be created.

Can someone help to automate these dates?

Sample data.xlsx

FrederikE · Answer

@Meghnagupta,

With v2021.1.

New Workflow1.yxmd

Meghnagupta · Answer

@FrederikE : Can you please screenshot or downgrade workflow maybe? Since workflow you have shared is of updated version and I am not able to see workflow.

FrederikE · Answer

Hey @Meghnagupta,

Not sure if I understand your dates, they appear to be pretty random.

Here is a flow that writes the Header for the current quarter and the following 3 quarters, and underneath the last day of the quarter each, hope that solves your problem.

(Note that I use DateTimeToday minus a few months (Filter nr. 2) since your data is not up to date, make sure to adjust this one)

New Workflow1.yxzp