IF Statement

[Kristie_Pires]

Hello there,

I need help writing an IF statement or whatever formula to get what I need. I have the first piece which is (if the "Last Change Dt" happened between "From" and "To" then the column "Change or No Change" is populated with "Change".

IF [Last Change Dt] > [From ] and [Last Change Dt] < [To] then "Change" else "No Change" endif

However, I was asked to say "No Change" whenever the "Last Change Dt" happened any date greater than 2 months ago (it has to be dynamic as I use it every month).

Any ideas would help :) 

From	To	Last Change Dt	Change or No Change
06/27/2022	07/28/2022	01/01/2019	No Change
06/13/2022	07/12/2022	01/01/2016	No Change
06/01/2022	07/01/2022	01/01/2016	No Change
06/08/2022	07/10/2022	07/05/2022	Change
06/04/2022	07/04/2022	07/05/2022	No Change
05/25/2022	06/25/2022	06/18/2019	No Change
06/02/2022	07/02/2022	06/03/2015	No Change
06/10/2022	07/10/2022	06/21/2021	No Change

[flying008 · Accepted solution]

Hi, @Kristie_Pires 

Try this formula:

IF DateTimeDiff(DateTimeAdd(DateTimeNow(),-2,"months"),DateTimeParse([Last Change Dt],"%m/%d/%Y"),"day") >1 THEN "No Change" 
ELSEIF [Last Change Dt] > [From] and [Last Change Dt] < [To] 
then "Change" 
else "No Change" endif

[Qiu · Accepted solution]

@Kristie_Pires 
similar with the approach @flying008 , but added the DateTime Conversion part.

[binuacs · Accepted solution]

@Kristie_Pires Another way of doing this with the Multi-Field formula

[Kristie_Pires]

Thank you so much all of you for the different solutions! They all work for what I needed 😊

[Qiu]

@binuacs 
Nice one on using Multi-column function for the DateTime Conversion part. 😁