Selecting Range of Dates based on two calculated fields and TimeStamp field.
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.