Combine two Expressions into one?

[drex]

Can someone tell me how I can combine both expressions in one for a query? I tried commas and brackets without avail.

Expr1: Replace([ITSM Start Date_Time]![Start Time],"T"," ")

Expr2: Left([ITSM Start Date_Time]![Start Time],Len([ITSM Start Date_Time]![Start Time])-14)


Here is the original data I am trying to convert.

Start Time
2014-01-15T08:56:00.0000000-00:00

Thanks,

[JoeM]

Try replacing both instances of [ITSM Start Date_Time]![Start Time] in your second expression with the formula from your first expression.

[drex]

This worked. Thank you!


Expr1: Left(Replace([ITSM Start Date_Time]![Start Time],"T"," "),Len(Replace([ITSM Start Date_Time]![Start Time],"T"," "))-14)