removing words in a string

[Pomna]

Hello experts I need your help trimming a string

I have a list of strings like below

Alice Anto (QueensLake\AliceA)

Allen Wendy (QueensLake\AllenW)

Dilys Agnes (QueensLake\DilysA)

I need to trim from  '('. I need just the first two words.

I also need to trim the following 

2017-04-08 TO4-32:36:29.2Z

2018-04-07 TI8-32:36:29.2Z

I need my date to read  YYYY-MM-DD HH:MM (like 2018-04-27 32:36). 

 Thanks for your suggestions

[Pomna]

Thank you for your suggestions. The following code worked for me 

Left([createdDate], Len(Trim([createdDate])) - 8), Date([createdDate],'YYYY-MM-DD hh:mm') as MyCreatedDate

and I got  my date and time formatted as below which is exactly as I want.

[sunny_talwar]

Great, glad you managed to fix it on your own.