[RESOLVED] Another Date Issue

[Dan_Particle]

Hi,
I'm having a problem running a MSSQL Stored procedure from php which requires a date as a parameter.

The MSSQL Datefield is smalldatetime format.
I have formated the date using date function to match the format but the query has a trouble with the slashes.

Is there some way to delimit slashes in the query.!!

$qryRaces="dbo.Web_MeetingList R,$thisdate";

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '/'., SQL state 37000 in SQLExecDirect in

Any help greatly appreciated
Cheers
DanP

[Dan_Particle]

Uhhhh...
just needed this...
$thisdate=date("ymd");