0

Hi,

I need to exclude any rows where the ASX_Prices.Date is a weekend. The date format is yyyy/mm/dd 2013/03/17.

Ideally I would like to add another WHERE clause.

WHERE ASX_Prices.Date !=weekend date?????

$sql="SELECT Distinct ASX_Prices.ASX_Code, ASX_Prices.ASX_Price, ASX_Prices.Date, Company_Information.Company_Name
        FROM ASX_Prices, Company_Information 
        WHERE ASX_Prices.ASX_Code = Company_Information.ASX_Code 
        AND DateDiff(now(), ASX_Prices.Date)<=7
        ORDER BY ASX_Prices.ASX_Code ASC, ASX_Prices.Date ASC";

Thanks

Matt.

1
Contributor
1
Reply
8
Views
4 Years
Discussion Span
Last Post by mathieu89
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.