Question Status

Verified
veeru ogu asked a question on 19 Feb 2014 3:44 AM
Hi, Give an example expression for time field in ssrs report. I want to show the data like 08:36:56. I tried in this way " =format(Fields!PerformedTime.Value,"##:##:##")" but the output shown like this 08:72:95 Thanks in advance
Reply
Verified Answer
Denis Macchinetti responded on 19 Feb 2014 4:34 AM

Hi Veeru

PerformedTime field is a Integer or what else ?

If Integer, have a look on daxdilip.blogspot.it/.../tip-ssrs-time-format-functions-for.html

Regards

Thanks & Regards

Denis Macchinetti

Technical Architect

Respect the provided answers from other community members. Don't provide or do not copy the same answer to the same thread. Additional insights are welcome!

Reply
veeru ogu responded on 19 Feb 2014 10:17 PM

Hi Denis,

      Thank you for providing the solution.

Regards

veeru

Reply
Denis Macchinetti responded on 19 Feb 2014 11:53 PM

Great

please, set the answer as verified.

Thanks so much

Regards

Thanks & Regards

Denis Macchinetti

Technical Architect

Respect the provided answers from other community members. Don't provide or do not copy the same answer to the same thread. Additional insights are welcome!

Reply
Verified Answer
Denis Macchinetti responded on 19 Feb 2014 4:34 AM

Hi Veeru

PerformedTime field is a Integer or what else ?

If Integer, have a look on daxdilip.blogspot.it/.../tip-ssrs-time-format-functions-for.html

Regards

Thanks & Regards

Denis Macchinetti

Technical Architect

Respect the provided answers from other community members. Don't provide or do not copy the same answer to the same thread. Additional insights are welcome!

Reply