Try resolving getdate() before the SQL and referenece
a variable that is populated by getdate().

Good Luck;

Cash Cloister
--- Roel Dancel <roel_d@y...> wrote:
> Here is my code kindly check it if it's right:
> 
> SELECT id, MAX(servicedate) AS ServDate
> FROM service
> WHERE DATEDIFF(day, ServDate, getdate()) <= 30
> GROUP BY ID
> 
> Im using a Visual Basic SQL Builder. I put it in a
> database designer.
> Im getting an "Undefined function 'getdate' in
> expression." error. Dont 
> know what to do.
> 
> Roel Dancel:)


__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com