Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Great, glad you managed to fix it on your own.