How do I pull the current month for use in pivot table start date?

I am having trouble starting my pivot table data from the first of the current month. The "Now" function is too specific. I also have tried Month(now) but that doesn't work. Here is what i have:

Please Login or Register  to view this content.