topic Re: Date Field Conversion in QlikView https://community.qlik.com/t5/QlikView/Date-Field-Conversion/m-p/127851#M756046 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214958_Capture.PNG" style="height: auto;" /></P><P><IMG alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/214959_Capture1.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 03 Oct 2018 02:37:10 GMT qlikviewwizard 2018-10-03T02:37:10Z Date Field Conversion https://community.qlik.com/t5/QlikView/Date-Field-Conversion/m-p/127849#M756044 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a date field with the data showing as follows: 20180927</P><P></P><P>I would like to create another 2 fields for Year and Month</P><P></P><P>Year should be ‘2018’</P><P>Month should be ‘Sep’</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-Field-Conversion/m-p/127849#M756044 Anonymous 2020-11-25T16:16:04Z Re: Date Field Conversion https://community.qlik.com/t5/QlikView/Date-Field-Conversion/m-p/127850#M756045 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>Year(Date#(DateField, 'YYYYMMDD')) as Year,</P><P>Month(Date#(DateField, 'YYYYMMDD')) as Month,</P></BODY></HTML> Tue, 02 Oct 2018 14:48:04 GMT https://community.qlik.com/t5/QlikView/Date-Field-Conversion/m-p/127850#M756045 sunny_talwar 2018-10-02T14:48:04Z Re: Date Field Conversion https://community.qlik.com/t5/QlikView/Date-Field-Conversion/m-p/127851#M756046 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214958_Capture.PNG" style="height: auto;" /></P><P><IMG alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/214959_Capture1.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 03 Oct 2018 02:37:10 GMT https://community.qlik.com/t5/QlikView/Date-Field-Conversion/m-p/127851#M756046 qlikviewwizard 2018-10-03T02:37:10Z