Previous Quarter

[ludag]

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.

[PhilipMannering · Accepted solution]

Hi @ludag 

Perhaps something like this,

[atcodedog05 · Accepted solution]

Hi @ludag 

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

Workflow:

Hope this helps : )