Need to automate date column.

[Meghnagupta]

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? 

[jbravman_]

one method would be to just give the column names Month 1, month 2, month 3, etc. Then in a second dataset, calculate said column names and then use a dynamic rename to bring them in. Note that some characters may not be visible in the header due to how alteryx works with column names. 

Alternately you can try to build a template file/excel file that you write to a specific range and overwrite it that way. G1:J1 with a dataset; G2:J2 with a dataset then C3:J12 with a dataset. 

[FrederikE]

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) 

[Meghnagupta]

@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]

@Meghnagupta,

With v2021.1.