Condition given based on Dates

[Sanjana_HS]

Hi ,
I am trying to achieve this:
If proposed Hire date coloumn is having dates from November or after,(can be any date of November) then I want in "SIRVA/ILH No Relo Report" coloumn to Print "too far out".

Attached excel file below

[Rana_Kareem]

Hi @Sanjana_HS ..

You can achieve this by using this expression while selecting "SIRVA/ILH No Relo Report" column in Formula Tool:

IF [Proposed Hire Date] >= "2023-11-01"
THEN "Too Far Out"
ELSE [SIRVA/ILH No Relo Report]
ENDIF