Date Time strings in SQL 2000 should be encased in #'
so your end query should essentially look like this:
Select sum(C901001003-C901001002) from T255 Where C3 > #10/7/2007 12:00:00
AM#
Hope This Helps,
Matt
On 10/9/07, Bao, Hui-Qing <[EMAIL PROTECTED]> wrote:
>
> **
>
> Hello All,
>
>
>
> I
tober 09, 2007 1:54 PM
To: arslist@ARSLIST.ORG
Subject: Re: How to pass Date/Time varible to SQLstatement
Hui,
If you only want to use the integer value of a date/time, first set the
value of $Start Date1$ to a temp integer value field. Then run the
command:
Select sum(C901001003-C9010
nal
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bao, Hui-Qing
Sent: Tuesday, October 09, 2007 1:47 PM
To: arslist@ARSLIST.ORG
Subject: How to pass Date/Time varible to SQLstatement
Hello All,
I have a SQL statement in Set Fi
Hello All,
I have a SQL statement in Set Field action, and I have to pass a
Date/Time variable ($Start Date1$) to the query:
Select sum(C901001003-C901001002) from T255 Where C3 > $Start Date1$
I got incorrect syntax error. The sql statement looks like this the
database log:
Select
4 matches
Mail list logo