If-Then

Need help with If-Then Expression

Hello everyone,

I am using PeopleSoft Query 8.8x online, and need to write an expression that looks between two dates (provided by prompts) and does the following:

First, if the Hire Date is between the two prompt dates, it will return "New Hire"

Second, if the Termination Date is between the two dates, it will return "New Term"

Third, if those two conditions are not met, it will simply need to return "Existing"

I have been wrestling with this and cannot quite figure it out. I must use an expression as we do not have access to edit SQL.