Sys: Time Module Formula

lkrylov
New Contributor

Sys: Time Module Formula

Trying to understand what is wrong with this formula and why it doesn't give me 2019-2022. Instead, I only get 3 years, 2020-2022. If I change the formula to Prior Year -2 I get 2021-2022. Would appreciate any ideas. 

 

lkrylov_0-1609533069593.png

 

lkrylov_1-1609533113335.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: Sys: Time Module Formula

@lkrylov 

Make sure your "Prior Year" format matches what you're comparing to. In your case you want them to be PERIODS (months). 

See if that helps. You can also try converting to the year (period) or Year (Number) since that's what your testing for anyway. you don't really need to use months from what I can tell. Depends on your use case.


Jared Dolich

View solution in original post

2 REPLIES 2
JaredDolich
Moderator

Re: Sys: Time Module Formula

@lkrylov 

Make sure your "Prior Year" format matches what you're comparing to. In your case you want them to be PERIODS (months). 

See if that helps. You can also try converting to the year (period) or Year (Number) since that's what your testing for anyway. you don't really need to use months from what I can tell. Depends on your use case.


Jared Dolich

View solution in original post

lkrylov
New Contributor

Re: Sys: Time Module Formula

Thank you for the incredibly quick response Jared!

 

I tested some other options and found that this formula works. 

 

PERIOD(START()) <= Current Year + 1

 

Thanks for the tip on the Months. I realized that I had to also change the Summary to be Formula, Time: Any