Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ngumdo
Contributor

Re: removing words in a string

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.

clipboard_image_0.png

Re: removing words in a string

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