Skip to main content

If my event is September 2, 2025 (aka "program start date"), it would be in Quarter 3, 2025. But I need to list that commission would be paid the following quarter (aka "quarter earned", so Q4, 2025. Fiscal year runs Jan - Dec like the calendar.

I currently have the formula (see below), but its marking everything in FY 2024. instead of in the appropriate next quarter. I know I am missing a small tweak, but cannot figure it out!

 

'Q' &
IF(
ROUNDUP(MONTH({Program Start Date})/3, 0) = 5,
1,
ROUNDUP(MONTH({Program Start Date})/3, 0)
) &
" - FY" &
IF(
ROUNDUP(MONTH({Program Start Date})/3, 0) = 5,
25,
24)

 

EDITED:  Ha just use @Alexey_Gusev's formula in the next post instead, it's much cleaner!

Does this look right? 

 

 

 

'Q' &
DATETIME_FORMAT(
DATEADD(
{Program Start Date},
1,
'quarter'
),
'Q'
) &
" - FY" &
DATETIME_FORMAT(
DATEADD(
{Program Start Date},
1,
'quarter'
),
'YY'
)

 

 

 

Hi,
A "D.R.Y." version of formula: 😁

 

Reply


Terms & Conditions