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 |
Solved! Go to 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
@Kristie_Pires
similar with the approach @flying008 , but added the DateTime Conversion part.
Thank you so much all of you for the different solutions! They all work for what I needed 😊
@binuacs
Nice one on using Multi-column function for the DateTime Conversion part. 😁