I need to write a formula to return values based on a specific start date and a salary rate e.g.

If start date is before 01/08/2023 and salary is greater than £x, THEN ‘PMI’
If start date is after 01/08/2023 and salary is greater than £xx, THEN ‘PMI +
ELSE ‘No PMI’

I am new to this so bear with me – this is what I’ve tried so far!

CASE 
    WHEN [Start Date] >= 01/08/2023 AND [FTE Salary] > £40,000.00
    THEN 'PMI'

    WHEN [Start date] <01/08/2023 AND AND [FTE Salary] > £60,000.00
    THEN 'PMI'

    ELSE 'NO PMI'
END