topic Re: How to convert date format DD-MM-YYYY into Year ? in QlikView https://community.qlik.com/t5/QlikView/Re-How-to-convert-date-format-DD-MM-YYYY-into-Year/m-p/1882748#M1216948 <P>Hi Anil babu&nbsp;</P> <P>I am facing an issue with converting date and time to year . and i am new to qlik</P> <P>in the excel sheet the format has like 12/2/1987&nbsp; 12:00 ,i want to change&nbsp; as year , i am using in year filter&nbsp;</P> <P>please&nbsp;</P> <P>regards</P> <P>Naidu</P> Wed, 19 Jan 2022 11:39:15 GMT Niadu123 2022-01-19T11:39:15Z Re: How to convert date format DD-MM-YYYY into Year ? https://community.qlik.com/t5/QlikView/Re-How-to-convert-date-format-DD-MM-YYYY-into-Year/m-p/1882748#M1216948 <P>Hi Anil babu&nbsp;</P> <P>I am facing an issue with converting date and time to year . and i am new to qlik</P> <P>in the excel sheet the format has like 12/2/1987&nbsp; 12:00 ,i want to change&nbsp; as year , i am using in year filter&nbsp;</P> <P>please&nbsp;</P> <P>regards</P> <P>Naidu</P> Wed, 19 Jan 2022 11:39:15 GMT https://community.qlik.com/t5/QlikView/Re-How-to-convert-date-format-DD-MM-YYYY-into-Year/m-p/1882748#M1216948 Niadu123 2022-01-19T11:39:15Z Re: How to convert date format DD-MM-YYYY into Year ? https://community.qlik.com/t5/QlikView/Re-How-to-convert-date-format-DD-MM-YYYY-into-Year/m-p/1883550#M1216949 <P>maybe like</P> <LI-CODE lang="markup">Year(Timestamp#(YourExcelField,'MM/DD/YYYY hh:mm')) as YourYearField</LI-CODE> <P>?&nbsp;</P> Thu, 20 Jan 2022 20:26:21 GMT https://community.qlik.com/t5/QlikView/Re-How-to-convert-date-format-DD-MM-YYYY-into-Year/m-p/1883550#M1216949 MarcoWedel 2022-01-20T20:26:21Z