rivet

calculate first month of quarter

Discussion created by rivet on Sep 21, 2015
Latest reply on Sep 22, 2015 by erolst

how can I find the first month of a quarter.

 

I found my quarter with:  ( current date: sep 21 )

Ceiling ( Month( Get ( CurrentDate ) ) /3 )

returns 3

 

I could hard code it:

Choose ( Ceiling ( Month( Get ( CurrentDate ) ) /3 )  ; 0;1;4;7;10 )

 

But I am looking for something to handle various fiscal starts.

Outcomes