Date calculation

Hi Alteryx Community

How do I calculate a start date with a known end date, for quarterly dates?

Ex. Reporting date = 30 September 2020. I want to calculate the start date of 1 July 2020.

Date Time

Accepted answers

I mocked up an example workflow. Tell me if it's what you want or not.

Cheers,

Jean-Baptiste

I mocked up an example workflow. Tell me if it's what you want or not.

Cheers,

Jean-Baptiste

There is a brilliant workflow made by @jdunkerley79 that will sort your problem:

Thanks so much! Works perfectly. Such a simple solution.

Thanks so much! works perfectly!

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Hope this one works for you!
I consider the year might be a variable.