IF Statement

Question

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 :)

FromToLast Change DtChange or No Change06/27/202207/28/202201/01/2019No Change06/13/202207/12/202201/01/2016No Change06/01/202207/01/202201/01/2016No Change06/08/202207/10/202207/05/2022Change06/04/202207/04/202207/05/2022No Change05/25/202206/25/202206/18/2019No Change06/02/202207/02/202206/03/2015No Change06/10/202207/10/202206/21/2021No Change

flying008 · Accepted Answer

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 Answer

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

binu_acs · Accepted Answer

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