I created a "on hold date" that gets populated when a deal stage is set to "On Hold".

I want to have a weekly report sent to me every friday night with all the deals that were put on hold that week, I think the best way to do is filter by "on hold date" (my custom field) to "current week".

The problem is this field doesnt appear as a choice in the drop down menu when creating the filter...