Sign Up ›
  • Lindsay Paulson 15
  • NEWBIE
  • 0 Points
  • Member since 2018
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
2 replies

Formula Field: Creating field to show scheduled interview date using Relevant Date: LAST WEEK

I currently have a formula field that shows the Upcoming Interview Date, which evaluates our six Client Interview Date fields on the object and displays the next upcoming interview date. 

I am in need of a similar formula field that will display any date scheduled for the previous week (rolling basis). FYI, our "week" begins on Monday for our org. Any ideas?

Thanks in advance!
2 replies

Formula Field: Creating field to show scheduled interview date using Relevant Date: LAST WEEK

I currently have a formula field that shows the Upcoming Interview Date, which evaluates our six Client Interview Date fields on the object and displays the next upcoming interview date. 

I am in need of a similar formula field that will display any date scheduled for the previous week (rolling basis). FYI, our "week" begins on Monday for our org. Any ideas?

Thanks in advance!