Database Query

[John]

Hi,
I am trying to run a custom query in Frontpage. This query works fine when
my DBA runs it against MS SQL. I can't get it to work. I keep getting an
error that says error near '>'

Can anyone help with this?

select left(d.batchstartdatetime,11) as
BatchDate,d.batchseqnum,d.envelopeseq from debit d, envelope e where
d.batchstartdatetime>=GetDate() and d.batchstartdatetime<= somemore
stuff.....

It seems to be stopping at the >

Thanks!

 

[McCabe's Minuteman]

Maybe force it to process the qualifier in order...

select left(d.batchstartdatetime,11) as
BatchDate,d.batchseqnum,d.envelopeseq from debit d, envelope e where
((d.batchstartdatetime >= GetDate()) and (d.batchstartdatetime <=
somemore
stuff.....))

 

[John]

Hi,
I did get it to work. Thanks! But I found another problem in that using
GetDate also gets the time. This is to exact for what I am looking for. I
than tried Date but got back and error saying that it doesn't support that
function. I am using MS SQL and IIS and Frontpage.

What I am trying to get is just today's date. Something like 8/6/2004. This
way I can get everything from today.

Thanks for your help!

John

 

[McCabe's Minuteman]

Try:

FORMAT(date,'mm/dd/yy')

in place of GetDate()