Display string date time field as only time

[AcctSolver]

I am working with a model in Microsoft Reporting Services Report Builder 3.0. I need to take a string date field from the model that is formatted mm/dd/yyyy hh:mm:ss and display it as only hh:mm:ss. Please advise as to how that can be accomplished.

 

[jjefferson]

You should be able to right-click the textbox that contains your column data reference, select "Text Box Properties...", in the dialog select "Number" in the left pane, then select "Time" in the right pane under "Category:", then select "13:30:00" in the "Type:" section. This should establish the formatting for that cell that you desire.