Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Previous Quarter

ludag
5 - Atom
‎01-10-2022 10:21 AM

hi,

 

Do you have any idea how to create dynamic previous quarter(s) calculations and find first day of quarter and last day of quarter based on datetimenow() only.

 

Datetimenow () = 10 Jan 2022

Previous quarter = Q4 2021

Previous quarter -1 = Q3 2021

First day of previous quarter = 1 Oct 2021

Last day of previous quarter = 31 Dec 2021

First day of previous quarter -1 = 1 Jul 2021

Last day of previous quarter -1 = 30 Sep 2021

 

I need calculations to be dynamic.

 

Tkank you very much in advance.

 

 

Labels:
Reply

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula
‎01-10-2022 10:35 AM

Hi @ludag 

 

Perhaps something like this,

PhilipMannering_0-1641839698034.png

 

dynamic quarters.yxmd
Reply
atcodedog05
22 - Nova
22 - Nova
‎01-10-2022 11:04 AM

Hi @ludag 

 

My take on this. I am have taken more entries for testing replace [Today] with datetimetoday()

 

Workflow:

atcodedog05_0-1641841986559.png

 

Hope this helps : )

Previous Quarter.yxmd
Reply
Copilot AMA
License admin COmmunity Live
Labels
Top Solution Authors
View All