Discussion board where members can get started with QlikView.
I want to convert the following date (getting as text from database) to date format as 'YYYY-MM-DD': "2009-12-18T10:30:38.000Z".
Following command is not working because it is a text:
Go to Solution.
Try this its working
date(date#(myDate,'YYYY-MM-DD hh:mm:ss.fff),'YYYY-MM-DD')It's possible that you have to loose the T and Z since that can't be found in documentation.