Forum Discussion
Solved
DATEDIFF help
Hi, I have searched the forums for the problem I am having and cannot seem to find the exact problem, so hope you can help! I am trying to work out the difference between two dates in months,...
Elder22 so do you want to ignore the opportunity dates that are > than today?
if so its really quite simple, you can ignore it until its relevant
DateDiff =
IF (
TODAY () > Opportunity[Close Date],
DATEDIFF ( Opportunity[Close Date], TODAY (), MONTH ),
0
)
Elder22 so do you want to ignore the opportunity dates that are > than today?
if so its really quite simple, you can ignore it until its relevant
DateDiff =
IF (
TODAY () > Opportunity[Close Date],
DATEDIFF ( Opportunity[Close Date], TODAY (), MONTH ),
0
)
Hello,
Thanks for your response - this worked fine for me, thanks very much I will mark as solved.
