Date Minus X number of days
I have leads that populate a custom field marked expiration date. I need to set up a report that will show all leads that are three days before this expiration date. I can bring up the expiration date in both standard and advanced filters but there are no options for 3 days before this date. I could use a between date filter but i would have to update that daily and that will not work. Are there any filters that will sort by a custom number of days? Or is there a way to filter by a date in a custom field. For example if i set up another custom field that was expiration date minus 3 days, could i create a filter that displays all leads that are between 'lead expiration date' and 'lead expiration date minus 3 days'?