title: Cannot format datetime in SQL Server Reporting Services report builder
body: <p>None of the previous questions/answers on this topic are working for me; I'm a bit baffled. I've inherited my first SQL Server Reporting Services Report Builder report and was given the seemingly simple task of changing what was a date to a datetime. As you can see below I've successfully modified the underlying query and am getting back datetime types but I cannot FORMAT them as such on the report. </p>
  
  <p>Results of my query:</p>
  
  <p><a href="https://i.stack.imgur.com/c0Pqv.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/c0Pqv.jpg" alt="enter image description here"></a></p>
  
  <p>My first instinct was that simply changing the type of the column (<code>FirstProcessorCompletedDate</code>) from date to datetime would make cue the report tool in on displaying date and time, but no luck. So...</p>
  
  <p>Previous experience with report building tools told me to take the existing reference to the field and replace it with a format statement for that field, kind of like this:</p>
  
  <p><a href="https://i.stack.imgur.com/yhNfo.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yhNfo.jpg" alt="enter image description here"></a></p>
  
  <p>Unfortunately, whatever I add here is getting interpreted as LITERALS by the report builder upon execution.  AND YES, I DID TRY AN "=" IN FRONT OF THE FORMAT STATEMENT.  This is just one variation of what I've tried.</p>
  
  <p><a href="https://i.stack.imgur.com/xI25G.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xI25G.jpg" alt="enter image description here"></a></p>
  
  <p>Clearly this is not the old SSRS-type report building I am used to.  I've Googled the heck out of this and searched Stack Overflow but no joy on the answer.  I've looked a little at Calculated Fields but this seems like overkill.  I don't want to calculate something, just format it.</p>
  
  <p>What am I missing?</p>