A cool function that can be used to pass dates

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

A cool function that can be used to pass dates

Author

Topic

kdnichols
Posting Yak Master

232 Posts

Posted - 2007-01-05 : 08:54:42

Hello All,

I thought I would share some knowledge for all the help that has been given to me and ask a question at the same time.

You can use this in a parameter to pass the date as a string. Be sure to use the ( ) at the end to pass the string.


Parameters!SummaryBy.Value = "Date Received", Fields!DateReceived.Value.toString( )

I am trying to using the date time in this format:


=FormatDateTime(Fields!DateReceived.Value,2)

Is there a way to use the VB Script function above in the FormatDateTime to use in the .toString()?

Thanks In Advance.

Kurt

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-05 : 10:14:23

What is the problem with the formulas above?

Peter Larsson
Helsingborg, Sweden

kdnichols
Posting Yak Master

232 Posts

Posted - 2007-01-05 : 10:23:20

Hello Peso,

In the second formula I just want it to display the date and not the time but I need to use the .toString().

What else do I need to do just to show the date and not the time?

Thanks,

Kurt

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources