Calculate different % if it is before specific time or after

[shasixz]

Can anyone please help me solve this issue? Before 1/1/2024 I have to calculate a 2.99% fee and after is different 2.29%. I am trying a formula but only giving the result after 31/12/2023, before the result is blank:

IF(

    {Date Booked},

    IF(

        IS_AFTER(

                {Date Booked},

                DATETIME_PARSE(

                    '31/12/2023',

                    'DD/MM/YYYY'

                    )

                ),

({Total due}-(2.29*{Total due})/100)+{Manual Rate}),

IF(

           IS_BEFORE(

                {Date Booked},

                DATETIME_PARSE(

                    '1/1/2024',

                    'DD/MM/YYYY'

                    )

                ),

({Total due}-(2.99*{Total due})/100)+{Manual Rate})

)

[shasixz]

Is there any moderator that can assist with this?

[shasixz]

I keep trying but is hard, anyone to give me an idea how to solve this?