Date_add in mysql

[otuatail]

$sqlAllData = "SELECT * FROM Bank_Data WHERE EntryDate > '" . $StartDate . "' AND EntryDate < DATE_ADD('$StartDate', 6 WEEK) ORDER BY EntryDate ASC, Output";


echo = SELECT * FROM Bank_Data WHERE EntryDate > '20-Jul-2015' AND EntryDate < DATE_ADD('20-Jul-2015', 6 WEEK) ORDER BY EntryDate ASC, Output

I copied this from the MySQL site but can't get it to work.

 

 

[otuatail]

SELECT * FROM Bank_Data WHERE EntryDate > '2015-07-20' AND EntryDate < DATE_ADD(2015-07-20, 6 WEEK) ORDER BY EntryDate ASC, Output

Sorry should have reversed the date but it still fails.

Now

[Ch0cu3r]

You need the  INTERVAL  keyword before  6 WEEK

$sqlAllData = "SELECT * FROM Bank_Data WHERE EntryDate > '" . $StartDate . "' AND EntryDate < DATE_ADD('$StartDate', INTERVAL 6 WEEK) ORDER BY EntryDate ASC, Output";

[Barand]

or instead of the DATE_ADD() function you can just use

... AND EntryDate < '$StartDate' + INTERVAL 6 WEEK

[otuatail]

Thanks for both of those suggestion. It works now.