IF PERIOD formula to return certain condition

[coding123456]

I have table report looks like the attached

The period End/Start Represents the Month.Year 008.2026

I need a formula where it the Periods does not exceed the Present contract end to take the 8%, if exceeds to take the new rate example

The current formula applied seems neglected the Year. The formula reads the logic of the front 3 digits. How can i make this work?
Present =IFNA(IFS(L$46 <=$B$34,$B$35,L$46>=$C$34,0)*L50,"Please Check Period")
Future =IFNA(IFS($C$34 = "", "",L$46 <=$B$34,0,L$46>=$C$34,$C$35)*L$50,"Please Check Period")

 

[Neeljy21]

1. Extracts the year from 008.2026 using RIGHT(L$46,4).
2. Extracts the month using LEFT(L$46,3), then converts it to two digits using TEXT(LEFT(L$46,3)*1,"00").
3. Combines them into a YYYYMM numeric format for accurate comparison.

This ensures that 008.2026 is compared as 202608, properly considering both month and year.