This content has been marked as final. Show 2 replies
I have connected iAuditor with Qlik Sense. Once extracted there is a column named "DateCompleted" with a date notification e.g. 13 February 2018 01:50 PM
From this i want to create separate fields [day], [month], [year]. As the months keep changing (in length characters) its not working to use like Right (DateCompleted,8) as Time etc. Anyone a idea how to script this?
Thanks in advance!!!