SQL statement issue

[Mdiaz]

I am having a problem with the following statement. Can you folks help out?

sqlstatement="SELECT EventDate, detail FROM calendar WHERE (((DatePart('ww',EventDate))=" & datepart("ww",Date()) & " And ChapterID=" & Session("Chapter") & ")) ORDER BY EventDate"

I am getting the following error:

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid parameter 1 specified for datepart.

Thanks.

 

[JayKusch]

do not put '' and "" around 'ww' and "ww"

Thanks

J. Kusch

 

[SQLBill]

As Jay points out, it's those quotes (single and double) around the ww in the DATEPART. The datepart (ww, dd, etc) is NOT a string. It's a TSQL command (or a portion of it), so it doesn't go in quotes.

-SQLBill

 

[Mdiaz]

Thanks for your help.

OK, I made the changes and now I'm getting the following error: Invalid procedure call or argument: 'DatePart'

Here is the entire section of code:

If Session("ChapterID")<>"" Then
sqlstatement="SELECT EventDate, detail FROM calendar WHERE (((DatePart(ww,[EventDate]))=" & datepart(ww,Date()) & " And ChapterID=" & Session("ChapterID") & ")) ORDER BY EventDate"
Else
sqlstatement="SELECT EventDate, detail FROM calendar WHERE (((DatePart(ww,[EventDate]))=" & datepart(ww,Date()) & " And ChapterID=1)) ORDER BY EventDate"
End If


I think we are close...

 

[sunila7]

use getdate() instead of Date(), and I Think there is a bracket missing here:

(((DatePart(ww,[EventDate]))
Should be
(((DatePart(ww,[EventDate])))="





Sunil