topic Help with trim in QlikView https://community.qlik.com/t5/QlikView/Help-with-trim/m-p/982958#M952909 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P></P><P>I am trying to trim a date field so i have just the year. I have searched the net to no avail. Ihave tried this but no luck, Please could someone help ?</P><TABLE><TBODY><TR><TD>Payment_A_Date,Left(Payment_A_Date,4)&nbsp;&nbsp;&nbsp; </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>as myYear,</TD></TR></TBODY></TABLE><P></P><P></P><P><IMG alt="trim.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107019_trim.jpg" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2015 12:49:26 GMT 2015-11-25T12:49:26Z Help with trim https://community.qlik.com/t5/QlikView/Help-with-trim/m-p/982958#M952909 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P></P><P>I am trying to trim a date field so i have just the year. I have searched the net to no avail. Ihave tried this but no luck, Please could someone help ?</P><TABLE><TBODY><TR><TD>Payment_A_Date,Left(Payment_A_Date,4)&nbsp;&nbsp;&nbsp; </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>as myYear,</TD></TR></TBODY></TABLE><P></P><P></P><P><IMG alt="trim.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107019_trim.jpg" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2015 12:49:26 GMT https://community.qlik.com/t5/QlikView/Help-with-trim/m-p/982958#M952909 2015-11-25T12:49:26Z Re: Help with trim https://community.qlik.com/t5/QlikView/Help-with-trim/m-p/982959#M952910 <HTML><HEAD></HEAD><BODY><P>In the script:</P><P></P><P>YEAR(Payment_A_Date) AS myYear</P></BODY></HTML> Wed, 25 Nov 2015 12:52:48 GMT https://community.qlik.com/t5/QlikView/Help-with-trim/m-p/982959#M952910 roger_stone 2015-11-25T12:52:48Z Re: Help with trim https://community.qlik.com/t5/QlikView/Help-with-trim/m-p/982960#M952911 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Year(Date#(Left(Payment_A_Date, 4), 'YYYY')) as myYear</STRONG></P></BODY></HTML> Wed, 25 Nov 2015 12:53:10 GMT https://community.qlik.com/t5/QlikView/Help-with-trim/m-p/982960#M952911 sunny_talwar 2015-11-25T12:53:10Z Re: Help with trim https://community.qlik.com/t5/QlikView/Help-with-trim/m-p/982961#M952912 <HTML><HEAD></HEAD><BODY><P>year(urfieldname)</P></BODY></HTML> Wed, 25 Nov 2015 13:05:44 GMT https://community.qlik.com/t5/QlikView/Help-with-trim/m-p/982961#M952912 buzzy996 2015-11-25T13:05:44Z