2 Replies Latest reply: May 24, 2018 3:50 PM by Jeroen Lansbergen RSS

    Extract month from data input iAuditor in Qlik Sense

    Jeroen Lansbergen

      Hi there,

       

      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!!!