|
| ODBC |
 |
Thu, 11 Jan 2007 21:43:19 +130 |
Hi can anyone tell me how to filter information using the ODBC driver?
e.g. SELECT WHERE DATE(DateOfInv) > "1/4/2006"
Best regards
Ian Stephenson
SoEasyAccounting.com Ltd
www.soeasyaccounting.com
|
| Post Reply
|
| Re: ODBC |
 |
Fri, 12 Jan 2007 13:51:32 +000 |
Ian wrote:
> Hi can anyone tell me how to filter information using the ODBC driver?
> e.g. SELECT WHERE DATE(DateOfInv) > "1/4/2006"
>
> Best regards
> Ian Stephenson
>
> SoEasyAccounting.com Ltd
> www.soeasyaccounting.com
>
>
Assuming you mean from elsewhere to Superbase, try:
SELECT ... FROM ... WHERE DateofInv > -d{'1/4/2006'}
If you mean in the other direction, try using DAYS() not DATE.
|
| Post Reply
|
|
|
|
|
|
|
|
|
|