471,089 Members | 1,725 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,089 software developers and data experts.

date comparison

why does this sql statement continually produce a syntax error (missing operator)?

("SELECT * FROM [" & AccountAction & _
"] WHERE " & ActualDueDt & " <= " & ScheduleDate) & _
" AND " & DeleteInd & " = 'N'" & _
" AND IsNull(" & CompleteDt & ") = TRUE " & _
" AND (IsNull(" & RescheduleDt & ") = TRUE " & _
" OR " & RescheduleDt & " <= " & ScheduleDate & ")" & _
" AND (IsNull(" & FAReviewDt & ") = TRUE " & _
" OR " & FAReviewDt & " <= " & ScheduleDate & ")" & _
" ORDER BY " & SchedulingParameterString)

I have checked the statement line by line and the problem seems to be associated with the comparison of dates ie <=. I am using vb .net 2005 and access 2003

thanks for any help
May 5 '07 #1
0 1645

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

16 posts views Thread by Donnal Walter | last post: by
2 posts views Thread by Scott Knapp | last post: by
1 post views Thread by sylvian stone | last post: by
6 posts views Thread by MarkAurit | last post: by
3 posts views Thread by Tiya | last post: by
4 posts views Thread by blini | last post: by
3 posts views Thread by noone | last post: by
4 posts views Thread by anagai | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.