sql server reporting services: Hi

I need to know how to display current date in the report.
Do i need to do something with rdl.
I wrote one JScript function there for the display of the date but its not
working.
As I am using xslt also at the render of the report for the foprmatting
purposes, so I wrote the same Jscript there also but still it is not working.

Can u please guide me.
Thanks in advance.
--
Vishnu

There's a global parameter called Execution TIme. THis shows today's date.
It shows the date and time, but if you only want to show the date, use this:

=Format(Globals!ExecutionTIme, "d")

Or you can find it by connecting to a SQL Server database (like your
reportserver database) and do
select getdate()

With getdate(), you can do a lot of sql converts to get it to display in the
format you prefer.

select convert(varchar(10), GetDate(), 104) as ShowToday
will return
26.02.2006,

while
select convert(varchar(10), GetDate(), 113) as ShowToday
will return
26 Feb 2006 14:33:58.

Kaisa M. Lindahl

[quoted text, click to view]