Determining New Code Period Start Date when the setting is Last X Number of Days

Consider Below Data :
Today’s Date : April 07, 2025
New Code Setting : Last 180 Days
Project A :
Last Analysis Date : April 07,2025
Available Analysis Dates : Oct 11,2024 & Oct 04,2024
Project B :
Last Analysis Date : April 05,2025
Available Analysis Dates : Oct 12, 2024 & Oct 04, 2024

With the above Data, i would like to confirm how New Code Period Start Date is determined for the above projects.

Question 1 : Since the New Code settings is Last 180 Days, do we need to minus 180 days from today’s date or Last Analysis Date of a project ?
For project B, Today’s Date - 180 Days (or) April 05, 2025 (Last Analysis Date) - 180 Days. Which one is followed by SQ?

Question 2 : After Subtracting the 180 days from the respective date, if analysis is not available exactly on that date, how new code start date is determined.
For Project A, April 7, 2025 - 180 Days = Oct 9,2024 for which we don’t have analysis data. In this case, how New Code Period Start Date is determined out of below cases
CASE - 1 : Next Immediate Analysis after Oct 9,2024
CASE - 2 : Immediate Previous Analysis before Oct 9,2024
CASE - 3 : Analysis Date whichever is closer Oct 9, 2024
Out of above three cases, which one is considered.

Hi,

I don’t understand why you would analyze so infrequently. :sweat_smile:

And yes, there’s something tricky and confusing about when day-based New Code periods start. IIRC - and it’s been multiple years since I dug into this - the period is going to reach back 180 days, and use that analysis as a baseline. On 7 April, that would have been Oct 9th. Since there apparently wasn’t an analysis on the 9th(?) then it rolls forward in time to find the first analysis: the 11th. That would have been the baseline, and everything after that was “new”.

To be clear, what’s “new” is calculated at the time of the analysis. So it doesn’t matter what date you’re looking at the data, only when it was calculated.

 
HTH,
Ann