SSRS Formatting: Remove Date from DateTime


When writing reports, sometimes you need to remove the date and just view the time….perhaps in the case of an appointment time, or a manager is checking up on his/her employees because they didn’t finish something on time.

1) Make sure that your column is a textbox.  If not drag a textbox from the toolbox into the cell.

2) Right-click textbox, and choose ‘Text Box Properties…’

3) Click on ‘General’ on the left-hand side.  Look for the ‘Value:’ prompt, and click ‘fx‘.

4) Paste the following:


This code will take this:

2012-06-30 12:13:52.893

And format it to look like this:
12:13 PM

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

©  2014 Tropical Coding    |    Contact Us