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.
| Author |
Topic |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2005-05-25 : 13:52:26
|
| Is it possible to specify the format of this date from within a conditional expression syntax.Example:=IIF(Parameters!Date.Value Is Nothing, "SPT Database", "SPT Database thru " & (Globals!ExecutionTime, "MM/dd/yyyy"))Not working but will give an idea of what's trying to accomplish here.Output Example:If no date given then display: SPT DatabaseIf date given then display: SPT Database thru 01/02/2005 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-25 : 14:03:45
|
| You can use the DateFormat VB.NET function to change the format of a date. Google VB.NET DateFormat for details.Tara |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-05-25 : 14:19:25
|
| Thanks hehe...Here's a workable example in case someone need:=IIF(Parameters!Date.Value Is Nothing, "SPT Database", "SPT Database thru " & Format(Globals!ExecutionTime, "MM/dd/yyyy")) |
|
|
|
|
|
|
Globals!ExecutionTime format?