5 Replies Latest reply on Aug 7, 2015 7:06 AM by philmodjunk

    Selecting Range of Dates based on two calculated fields and TimeStamp field.

    bokenrosie

      Title

      Selecting Range of Dates based on two calculated fields and TimeStamp field.

      Post

      Much thanks to Phil for helping me calculate first and last date of month.

      I have DateRangeMonth (a calendar drop down to help user select the month they want results for) RangeFirstDay and RangeLastDay calculated fields and RecordCreatedDate (timestamp on a record).

      I am trying to perform a find that returns all records where RecordCreatedDate is between RangeFirstDay and RangeLastDay of that DateRangeMonth the user selected.  I've tried creating a button and using button setup method "perform find" and trying to use Range but cannot figure it out past that point.  

      I'm hoping to create a easy way to select all records in that date range.

      TIA