all groups > sql server reporting services > august 2004 >
You're in the

sql server reporting services

group:

datepart function not working


datepart function not working Cindy Lee
8/16/2004 5:11:13 PM
sql server reporting services:
when i put this in a text box, i get this error message:

="Includes Date:" & DatePart(""d"", Now() )



BC30518 Overload resolution failed because no accessible 'DatePart' can be
called with these arguments


Re: datepart function not working Jéjé
8/16/2004 9:16:56 PM
datepart is an SQL Server function, not a Reporting services function.
try this:

now().ToString("d")

write your RS function as VB.Net functions.

"Cindy Lee" <cindylee@hotmail.com> a écrit dans le message de
news:O4KxH7%23gEHA.3988@tk2msftngp13.phx.gbl...
[quoted text, click to view]

Re: datepart function not working Bruce Johnson [MSFT]
8/17/2004 11:24:17 AM
SQL Server Reporting Services 2000 supports a large number of VB .NET
functions including the date manipulation ones.
Included in this set a DatePart() function. Pleaser refer to MSDN for more
information.

--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

AddThis Social Bookmark Button