How to concatenate two time fields

• hazeleyre_23

  SSC-Addicted

  Points: 449

  More actions

  December 9, 2015 at 3:37 am

  #303154

  Hi,

  I am looking to concatenate two field times so it shows at 09:00 - 17:30.

  My two fields are: Fields!Shift_Start.Value and Fields!Shift_End.Value

  These fields are Time(0) data type in SQL.

  Is there a way of doing this?

  Thank you 🙂

• Ant-Green

  SSC Guru

  Points: 113563

  More actions

  December 9, 2015 at 4:42 am

  #1844853

  Not used time columns in SSRS so this may not work, but will need to create an expression in the tablix something like

  Fields!Shift_Start.Value + " - " + Fields!Shift_End.Value

  You may need to convert the values to strings first.

  Or do it at the DB layer and convert the times to varchar and use string concatenation something like

  convert(varchar(5),shift_start)+ ' - ' + convert(varchar(5),shift_end)