Formatting a date in the report title header

• system243trd

  Right there with Babe

  Points: 756

  More actions

  October 28, 2014 at 9:45 am

  #294578

  I want to be able to include the execution date and time in the report title header, so that it is formatted like

  14th March 2014, 15:30

  I have attempted to use the following formula (or something similar) but cannot get it to work

  =Format(Globals!ExecutionTime,"dd-mm-yyyy hh:mm" & " ")

  Please can anyone help?

• pietlinden

  SSC Guru

  Points: 63428

  More actions

  October 28, 2014 at 6:34 pm

  #1755391

  One option:

  =Format(Globals!ExecutionTime,"dd") & "th " & Format(Globals!ExecutionTime,"MMMM yyyy") & ", " & Format(Globals!ExecutionTime,"hh:mm")