If else statement with Let variable

[Yean]

Let FirstHalfDate = Date(MonthStart(Addmonths('2022-07-01',-6)),'MM');

Let SecondHalfDate = Date(MonthStart(Addmonths('2022-01-01',-6)),'MM');

Let CutOffDate = IF MONTH(TODAY()) <= 06 

                 THEN '$(FirstHalfDate)';

                 ELSE IF '$(SecondHalfDate)';

                 END IF

Hello, I want to use if else statement with the Let variable, above is what I typed but Qlik keeps on giving me error at the Let CutOffDate variable, anyone know where did I do wrong? 

Thanks in advance.

[sidhiq91 · Accepted solution]

@Yean  Could you please try the below expression. I got the desired output.

Let FirstHalfDate = Date(MonthStart(Addmonths('2022-07-01',-6)),'MM');

Let SecondHalfDate = Date(MonthStart(Addmonths('2022-01-01',-6)),'MM');

Let CutoffDate =if(Month(Today())<=06,'$(FirstHalfDate)','$(SecondHalfDate)');

If this resolves your issue, please like and accept it as a solution.

[Yean]

Thank you so much !!!!

I guess I've confused with SQL if else statement ><