Q34 - Adding DocDueDate...........aarrrggghhhhhh

[Former Member]

Can anyone explain why I get an error message when I try to insert:

t1.docduedate between [%1] and [%2]

or even

t1.docduedate >= '[%0]' and <= '[%1]'

into the 'WHERE' statement below.............

SELECT

t1.cardcode, t1.cardname,

sum(t1.doctotal-t1.vatsum) as 'Sales Value'

FROM

ordr t1

WHERE

t1.docstatus = 'O'

GROUP BY

t1.cardcode, t1.cardname

I find this even more confusing as everything is coming from a single table..........!!

Thanks,

Robin

[Former Member · Accepted solution]

Try:

SELECT

t1.cardcode, t1.cardname,

sum(t1.doctotal-t1.vatsum) as 'Sales Value'

FROM

ordr t1

WHERE

t1.docstatus = 'O' AND t1.docduedate >= [%0\] and t1.docduedate <= [%1\]

GROUP BY

t1.cardcode, t1.cardname

Thanks,

Gordon

[Former Member · Accepted solution]

Thanks Gordon,

Just having a 'moment'........!

Robin

[Former Member]

Hi Robin Bellion,

You can try this one,

and t1.docduedate >= [%0] and t1.docduedate <= [%1]

regards,

H2

Edited by: Hoe Pham Huy on Jan 24, 2011 3:16 PM

Edited by: Hoe Pham Huy on Jan 24, 2011 3:17 PM