• HelpWanted.ax730
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

Hi All,

 

This is probably a really noob question, but I'm just getting my head around things.

 

I have created a formula field called DaysSinceLastActivity, which does this:

 

ROUND(TODAY()-LastActivityDate, 0)

 

This returns an integer number for days between today and the LastActivityDate. 

 

The problem I am having is that if my guys put in reminders - activities to contact a lead at a particular point in the future, my "DaysSince" field starts returning a negative number: it subtracts (Activity Due Date) from (Today). 

 

Is there a way to get this formula to ignore future dates altogether, and roll with LastActivityDate's that are in the past only? 

 

I thought about having it return 0 if the number is negative, but that is basically wrong too.

 

Ideas?

 

Thanks in advance!

Nick