Power Pivot Help - SQL code working sort of?

I apologize if this isn't the right section of the forum to put this topic....didn't see one for power pivot. I'm running into two different errors I was hoping for some help on.

When I'm using PP and trying to bring down data from the SQL server I'm using the following code:

SELECT BILLING.BILLING_SOLD_ACCNO, BILLING.BILLING_ORIG_ORDNO, BILLING.BILLING_ORIG_ORD_DATE, BILLING.BILLING_ORIG_OPR, BILLING_ORDER_ITEMS.BILLING_ITEM
FROM BILLING INNER JOIN BILLING_ORDER_ITEMS ON BILLING.u2_id = BILLING_ORDER_ITEMS.u2_id
WHERE (((BILLING.BILLING_ORIG_ORD_DATE)>=6/1/2016));

My data comes in for the fields I want but it brings in the entire table instead of based on the date range that I'm trying to do. What am I doing wrong for setting the criteria I want that date range to be so it just brings in information starting at that date?

My other question is I was also trying to do one other criteria on the data coming in but it keeps getting errors....in that the 3rd line looked like:
WHERE (((BILLING.BILLING_ORIG_ORD_DATE)>=6/1/2016) AND ((BILLING.BILLING_ORIG_OPR) Not Like "WebSite"));

It had the same two lines as above before the third line. For the field Billing_orig_opr I'm trying to not bring in any data that has WebSite in that field but it doesn't seem to like that and I've tried to put it in a few different ways.

Can't figure what I'm doing wrong....Please help.


thank you.

Also posted this at:

http://chandoo.org/forum/threads/pow...sort-of.29936/