VBA Filter Date Rate

I'm facing a problem on a few levels. Let me explain what I would like to accomplish.

I would like to filter data I'm receiving by date paid, so I know what invoices have been paid for a specific month or date range. Date_Paid comes in a text value "3/18/2013 4:43:45 PM" as an example and I would like to know all invoice that have been paid for the month of April. I would like to know ways to accomplish this using VBA since I'm pulling the filter results from a list box of month values. Then I can move onto my next hurdle.

Test Payments Pivot-Table.xlsx

Sixthsense thank you for your quick response.

Please forgive me, I'm a C# coder that knows very little about excel. The edit you made helped me very much, now how do I change the listbox date selection to automatically change the pivot table date filter? For example, I would like to know all the invoices paid for January. Then I'm going to take my budget figures from another table to find out where I am each day. Thanks again.