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