ExecuteSQL Select Date Filed not working.

[Devin]

I'm tying to write an ExecuteSQL for charting.

I can get it to work with out selecting a Date Filed (OrderDate). What I want to do in the end is do a "Where OrderDate = mm/dd/yyyy" to filter out by date. But in testing I'm not even able to even get SELECT to work.

=================================
ExecuteSQL ("
SELECT SKU, SUM(Quantity) as ProductTotal
FROM LineItems
GROUP BY SKU
ORDER BY ProductTotal DESC FETCH FIRST 20 ROWS ONLY
"
; "|" ; ¶ )
=================================
 

[LAIRY]

Hi,

Try

    ORDER BY 2 DESC..... (ref to second column)

Good luck

G

 

Edited April 26, 2016 by LAIRY
spelling mistake