Forum Discussion
NickProp28
Post Partisan
Post PartisanDate difference and return TRUE/FALSE
Dear Community, DATE A DATE B 27/6/2020 29/6/2020 1/7/2020 29/6/2020 I looking for a formula that can substract (DATEA - DATEB) and return false/true if its more than 7 days. ...
if(abs(datediff([Date A],[Date B],Day)) <=7, "Yes","NO")
NickProp28
What is your formula? Should be like:Column = IF(DATEDIFF([Date A],[Date B],DAY)>7,TRUE(),FALSE())Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
NickProp28 , Something like this. Change as per need
if((abs(datediff([Date A],[Date B],Day)) <=7) || (isblank([Date A]) ||isblank([Date B]) ), "Yes","NO")
NickProp28Post Partisan
Post PartisanDear Anonymous amitchandak ,
Appreciate for the solution. It works perfectly for me.
May I ask, what should be the formula if either one of the Date (DateA/DateB) is blank. I want it return True instead of False.
Best thanks.
amitchandak
Super User
Super UserNickProp28 , Something like this. Change as per need
if((abs(datediff([Date A],[Date B],Day)) <=7) || (isblank([Date A]) ||isblank([Date B]) ), "Yes","NO")- NickProp28