How do I phrase the following?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian - 13 Oct 2005 15:25 GMT

I want to pull in plant numbers from only a certain date. How do I rephrase
the following statement so that it correctly pulls in the dates?

"( WERKS IN ('0383,0383') And DATUB > '" & varYesterday & "' & " )"

This currently does not work. Thanks for the help.

Reply to this Message

Alex Dybenko - 13 Oct 2005 19:15 GMT

Hi,
if you use JET database then date format should be #mm/dd/yyyy#
for SQL Server 'yyyymmdd'

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

>I want to pull in plant numbers from only a certain date. How do I
>rephrase
[quoted text clipped - 3 lines]
>
> This currently does not work. Thanks for the help.

Reply to this Message