How to concatenate a Date and Time field without messing up the format?

[astroboy]

I am trying to concatenate my text field and date and time field in calculated field, however, the format of my date and time field has additional 0's at the end of the time. Is there a way to avoid this from happening?

[princezuko]

Hello Astroboy,

You may use this formula to concatenate these two fields without changing the format of the date and time field. Please refer to this formula and modify it according to your field names:

'[@field:Text_Field]' + CONVERT(VARCHAR, [@field:Date_&_Time_Field], 22)