GETDATE()

I'm using SQL Server 2005 Repoting Services to find all funds availilble
before the current date. When I use GETDATE() I get an error ORA-00904. Any
other suggestions? I'm using Visual Studio to run SSRS.
ThanksJohn, I believe that you may be looking for NOW(). - RLF
"John" <John@.discussions.microsoft.com> wrote in message
news:64BFEA2C-8D4C-4215-B3B0-39B8930F0E6D@.microsoft.com...
> I'm using SQL Server 2005 Repoting Services to find all funds availilble
> before the current date. When I use GETDATE() I get an error ORA-00904.
> Any
> other suggestions? I'm using Visual Studio to run SSRS.
> Thanks|||GetDate() is specific to MSSQL. Try Sysdate instead.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"John" <John@.discussions.microsoft.com> wrote in message
news:64BFEA2C-8D4C-4215-B3B0-39B8930F0E6D@.microsoft.com...
> I'm using SQL Server 2005 Repoting Services to find all funds availilble
> before the current date. When I use GETDATE() I get an error ORA-00904.
> Any
> other suggestions? I'm using Visual Studio to run SSRS.
> Thanks