Command | Result |
FormatDateTime(Parameters!Date.Value,1) | Tuesday, April 10, 2007 |
FormatDateTime(Parameters!Date.Value,2) | 4/10/2007 |
FormatDateTime(Parameters!Date.Value,3) | 12:00:00 AM |
FormatDateTime(Parameters!Date.Value,4) | 00:00 |
...but the better way to do it would be to use ...
2) The Format command and specify the exact format you require. For example...
Command | Result |
Format(Parameters!Date.Value,"dd-MM-yyyy") | 10-04-2007 |
Format(Parameters!Date.Value,"dd/MM/yyyy") | 10/04/2007 |
Format(Parameters!Date.Value,"MMM-dd-yyyy") | Apr-10-2007 |
Format(Parameters!Date.Value,"MMM-dd-yy") | Apr-10-07 |
表达式示例
http://technet.microsoft.com/zh-cn/library/dd283099.aspx
换行
=Format(Fields!Today.Value,"MM月dd日") & vbCrLf & "aa"
VB换行符常量及其他常量
http://msdn.microsoft.com/en-us/library/f63200h0%28VS.80%29.aspx