I'm trying to create a User Defined Function which will return only records
with a date earlier than the current date. I tried using ,GETDATE() in the
criteria block of the date field but when I try to save the function I get
the error "ADO Error: Invalid use of 'getdate' within a function. I suppose I
could just make it a variable and then pass the current date to it but I
think the function should grab the date by itself. Anyone know why it won't?
Thanks

You have two options:

1) pass the date as a parameter (fast) ; or

2) create a view such as:
create view vNow
as
select getdate() as Now
go

....and get the current time from the view.
(slow)

Choose your weapon. :)


ML

---
http://milambda.blogspot.com/

No, you have to pass the date to the function.

HTH, Jens Suessmeyer.

Optimizing an IN clause
SQL 2k5 vs 2k - different results on same execution? ORDER BY prob
What is this called, and how to do it?
SQL Server vs the Competition
Select Records which are not present in second table