Friday, May 2, 2014

Sum Date Time data type

Hi Krishnakumar_Dev,


If we want to extract hour in a date time field, we can use hour function as below in Reporting Services.

=sum(hour(Fields!date.Value))


Besides, if this issue is still existed, Could you please post the screenshot about your dataset with sample data and desired result?



For more information about Date and Time Functions, please refer to the following link:

http://ift.tt/1h4oVLB


Thanks,

Katherine Xiong




Katherine Xiong

TechNet Community Support



No comments:

Post a Comment