blocks|key|120856|text|=Format(Now(),+"MM/dd/yyyy+hh:mm+tt")|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|120857|输出：|unstyled|120858|04/12/2013+05:09+PM|120859|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>=Format(Now(), "MM/dd/yyyy hh:mm tt")
</code></pre>

Output:

<pre><code>04/12/2013 05:09 PM
</code></pre>

blocks|key|338507|text|如果日期和时间在它自己的单元格(也称为textbox)中，那么您应该考虑将格式应用于整个textbox。这将创建到其他格式的更干净的导出；具体地说，该值将作为日期时间值导出到Excel，而不是字符串。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|338508|使用属性窗格或对话框将文本框的格式设置为"MM/dd/yyyy+hh:mm+tt“|338509|只有当datetime与另一个字符串连接时，我才会使用Ian的答案。|338510|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

If the date and time is in its own cell (aka textbox), then you should look at applying the format to the entire textbox. This will create cleaner exports to other formats; in particular, the value will export as a datetime value to Excel instead of a string.

Use the properties pane or dialog to set the format for the textbox to "MM/dd/yyyy hh:mm tt"

I would only use Ian's answer if the datetime is being concatenated with another string.

blocks|key|338539|text|嗨，朋友，请试着用这个表达你的报告|type|unstyled|depth|inlineStyleRanges|entityRanges|data|338540|="Page+"+%2B+Globals!PageNumber.ToString()+%2B+"+of+"+%2B+Globals!OverallTotalPages.ToString()+%2B+vbcrlf+%2B+"Generated:+"+%2B+Globals!ExecutionTime.ToString()|code-block|syntax|javascript|338541|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

hi friend please try this expression your report 

<pre><code>="Page " + Globals!PageNumber.ToString() + " of " + Globals!OverallTotalPages.ToString() + vbcrlf + "Generated: " + Globals!ExecutionTime.ToString()
</code></pre>

blocks|key|120944|text|我在SSRS+2005中使用了以下内容|type|unstyled|depth|inlineStyleRanges|entityRanges|data|120945|=Format(Globals!ExecutionTime,"MM-dd-yyyy"+&+"+")+
&+CStr(Hour(Globals!ExecutionTime))++&+":"
&+CStr(Minute(Globals!ExecutionTime))|code-block|syntax|javascript|120946|或|120947|=Format(Globals!ExecutionTime,"MM-dd-yyyy"+&+"+")+
&+Right("00"+&+CStr(Hour(Globals!ExecutionTime)),+2)
&+":"
&+Right("00"+&+CStr(Minute(Globals!ExecutionTime)),+2)|120948|基于评论：|120949|=Format(CDate(Globals!ExecutionTime),+"MM-dd-yyyy+hh:mm.ss")+|120950|120951|=Format(CDate(Globals!ExecutionTime),+"MM-dd-yyyy+HH:mm.ss")|120952|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|V|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|W|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|X|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|O|3|H|5|6|7|Z|8|@]|9|@]|A|$]]|$1|P|3|Q|5|D|7|10|8|@]|9|@]|A|$E|F]]|$1|R|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|S|$]]

I am using following in SSRS 2005

<pre><code>=Format(Globals!ExecutionTime,"MM-dd-yyyy" &amp; " ") 
&amp; CStr(Hour(Globals!ExecutionTime)) &amp; ":"
&amp; CStr(Minute(Globals!ExecutionTime))
</code></pre>

Or 

<pre><code>=Format(Globals!ExecutionTime,"MM-dd-yyyy" &amp; " ") 
&amp; Right("00" &amp; CStr(Hour(Globals!ExecutionTime)), 2)
&amp; ":"
&amp; Right("00" &amp; CStr(Minute(Globals!ExecutionTime)), 2)
</code></pre>

Based on comment:

<pre><code>=Format(CDate(Globals!ExecutionTime), "MM-dd-yyyy hh:mm.ss") 
</code></pre>

OR

<pre><code>=Format(CDate(Globals!ExecutionTime), "MM-dd-yyyy HH:mm.ss")
</code></pre>

blocks|key|338611|text|我正在用这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|338612|=Format(Now()，"dd/MM/yyyy+hh:mm+tt")|338613|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I am using this

=Format(Now(), "dd/MM/yyyy hh:mm tt")

blocks|key|338657|text|如果您单击报表上远离任意表的空白处，然后查看属性，则其中一个名为Language的Misc字段允许您选择要设置的语言，这样做之后，您就可以处理此问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|338658|=FormatDateTime(now,x)|code-block|syntax|javascript|338659|哪个x可以是1、2、3、4、5|offset|length|style|CODE|338660|entityMap^0|0|0|2|1|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

If you click on the empty spot on the report away from any table and then look in properties, one of the Misc fields is called Language which allows you to pick which Language you would like to set, which after doing so can play around with this 

<pre><code>=FormatDateTime(now,x)
</code></pre>

Which <code>x</code> can be 1, 2, 3, 4, 5

blocks|key|338670|text|=Replace(Format(CDate(Now()),"MM.dd.yyyy"),+".",+"/")|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|338671|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>=Replace(Format(CDate(Now()),"MM.dd.yyyy"), ".", "/")
</code></pre>

blocks|key|121035|text|希望这能有所帮助：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|121036|SELECT+convert(varchar,+getdate(),+100)+--+mon+dd+yyyy+hh:mmAM

SELECT+convert(varchar,+getdate(),+101)+--+mm/dd/yyyy+–+10/02/2008++++++++++++++++++

SELECT+convert(varchar,+getdate(),+102)+--+yyyy.mm.dd+–+2008.10.02+++++++++++

SELECT+convert(varchar,+getdate(),+103)+--+dd/mm/yyyy

SELECT+convert(varchar,+getdate(),+104)+--+dd.mm.yyyy

SELECT+convert(varchar,+getdate(),+105)+--+dd-mm-yyyy

SELECT+convert(varchar,+getdate(),+106)+--+dd+mon+yyyy

SELECT+convert(varchar,+getdate(),+107)+--+mon+dd,+yyyy

SELECT+convert(varchar,+getdate(),+108)+--+hh:mm:ss

SELECT+convert(varchar,+getdate(),+109)+--+mon+dd+yyyy+hh:mm:ss:mmmAM+(or+PM)

SELECT+convert(varchar,+getdate(),+110)+--+mm-dd-yyyy

SELECT+convert(varchar,+getdate(),+111)+--+yyyy/mm/dd

SELECT+convert(varchar,+getdate(),+112)+--+yyyymmdd

SELECT+convert(varchar,+getdate(),+113)+--+dd+mon+yyyy+hh:mm:ss:mmm

SELECT+convert(varchar,+getdate(),+114)+--+hh:mm:ss:mmm(24h)

SELECT+convert(varchar,+getdate(),+120)+--+yyyy-mm-dd+hh:mm:ss(24h)

SELECT+convert(varchar,+getdate(),+121)+--+yyyy-mm-dd+hh:mm:ss.mmm

SELECT+convert(varchar,+getdate(),+126)+--+yyyy-mm-ddThh:mm:ss.mmm|code-block|syntax|javascript|121037|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Hope this helps: 

<pre><code>SELECT convert(varchar, getdate(), 100) -- mon dd yyyy hh:mmAM

SELECT convert(varchar, getdate(), 101) -- mm/dd/yyyy – 10/02/2008 

SELECT convert(varchar, getdate(), 102) -- yyyy.mm.dd – 2008.10.02 

SELECT convert(varchar, getdate(), 103) -- dd/mm/yyyy

SELECT convert(varchar, getdate(), 104) -- dd.mm.yyyy

SELECT convert(varchar, getdate(), 105) -- dd-mm-yyyy

SELECT convert(varchar, getdate(), 106) -- dd mon yyyy

SELECT convert(varchar, getdate(), 107) -- mon dd, yyyy

SELECT convert(varchar, getdate(), 108) -- hh:mm:ss

SELECT convert(varchar, getdate(), 109) -- mon dd yyyy hh:mm:ss:mmmAM (or PM)

SELECT convert(varchar, getdate(), 110) -- mm-dd-yyyy

SELECT convert(varchar, getdate(), 111) -- yyyy/mm/dd

SELECT convert(varchar, getdate(), 112) -- yyyymmdd

SELECT convert(varchar, getdate(), 113) -- dd mon yyyy hh:mm:ss:mmm

SELECT convert(varchar, getdate(), 114) -- hh:mm:ss:mmm(24h)

SELECT convert(varchar, getdate(), 120) -- yyyy-mm-dd hh:mm:ss(24h)

SELECT convert(varchar, getdate(), 121) -- yyyy-mm-dd hh:mm:ss.mmm

SELECT convert(varchar, getdate(), 126) -- yyyy-mm-ddThh:mm:ss.mmm
</code></pre>

blocks|key|338722|text|首先到你的控制面板，选择日期，时间和数字格式。现在从下拉列表中选择英语(联合王国)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|338723|确保shor+date字段等于'dd/mm/yyyy‘。按Apply。现在转到SSRS，右键单击空白区域中的报告并选择属性。|338724|如果使用的是visual+studio，则将Language属性设置为=User!Language。|338725|如果使用的是报表生成器，则Language属性将出现在“本地化”部分。|338726|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

First go to your control panel , select Date , time and Number Format . Now select English(United Kingdom) from the drop down list. 

Make sure the shor date field is equal to 'dd/mm/yyyy'. Press Apply. Now go to SSRS and right click on the report in the empty space and select properties.

If you are using visual studio then set Language property equal to =User!Language. 

If you are using Report Builder then Language property will appear in Localization section.

on SSRS report I need to show <code>todays date and current time</code> 

i tried this <code>=FormatDateTime(Now,"MM/dd/yyyy hh:mm tt")</code> but this is not working for me giving an error.

Anyone please help me for <code>expression</code> ?

I want output display like <code>4/12/2013 12:05 PM</code>

How do I format date and time on ssrs report?

在SSRS报告上，我需要显示todays date and current time我尝试了这个=FormatDateTime(Now,"MM/dd/yyyy hh:mm tt")，但这对我不起作用，并给出了一个错误。有人能帮我一下expression吗？我想要类似4/12/2013 12:05 PM的输出显示

问如何格式化ssrs报告中的日期和时间？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何格式化ssrs报告中的日期和时间？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何格式化ssrs报告中的日期和时间？
EN