It seems to me that the SYSDATE command is not recognised in Base as it is
looking for a field header of that name.
Ron Ferguson
Kirill S. Palagin wrote:
dateField > SYSDATE - 30
does not work either, producing the same error message.
-----Original Message-----
From: Tom Chilton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 27, 2007 4:41 PM
To: [email protected]
Subject: Re: [users] Base - SELECT * FROM Table1 WHERE SYSDATE -
DateField > 30
Do you mean selecting records for the last month?
try
SELECT * FROM Table1 WHERE dateField > SYSDATE - 30
I think because you can take 30 days from a date but can't compare a
whole date to a single integer.
No doubt I'm wrong but give it a try...
change the > to < should do it if you want dates in the future
Hope this helps
On 27 Feb 2007, at 13:23, Kirill S. Palagin wrote:
Hello.
Our customer is trying to make statement SELECT * FROM Table1 WHERE
SYSDATE - DateField > 30 work and gets "Wrong data type in
statement..."
What would be correct statement to select rows with "DateField" older
than 30 days from now?
Thanks a lot.
WBR,
K. Palagin.
----------------------------------
Tom Chilton
[EMAIL PROTECTED]
----------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
