Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More

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.


Re: removing words in a string

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