topic Re: Hi Friends in QlikView https://community.qlik.com/t5/QlikView/Hi-Friends/m-p/678352#M1084483 <HTML><HEAD></HEAD><BODY><P>Hi Kalyan can you post some sample records</P><P></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 30 Jun 2014 11:04:14 GMT ashfaq_haseeb 2014-06-30T11:04:14Z Hi Friends https://community.qlik.com/t5/QlikView/Hi-Friends/m-p/678350#M1084481 <HTML><HEAD></HEAD><BODY><P>Hi friends</P><P>i'm having&nbsp; a date field not in correct format.Its in numeric value. I need to get the only year in the straight table.How can i fetch it .Can anyone suggest me how to do it?ASAP.</P><P></P><P>Regards</P><P>Krishna</P></BODY></HTML> Mon, 30 Jun 2014 10:57:37 GMT https://community.qlik.com/t5/QlikView/Hi-Friends/m-p/678350#M1084481 krishna20 2014-06-30T10:57:37Z Re: Hi Friends https://community.qlik.com/t5/QlikView/Hi-Friends/m-p/678351#M1084482 <HTML><HEAD></HEAD><BODY><P>=Year(MyDateField)</P></BODY></HTML> Mon, 30 Jun 2014 11:02:45 GMT https://community.qlik.com/t5/QlikView/Hi-Friends/m-p/678351#M1084482 Gysbert_Wassenaar 2014-06-30T11:02:45Z Re: Hi Friends https://community.qlik.com/t5/QlikView/Hi-Friends/m-p/678352#M1084483 <HTML><HEAD></HEAD><BODY><P>Hi Kalyan can you post some sample records</P><P></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 30 Jun 2014 11:04:14 GMT https://community.qlik.com/t5/QlikView/Hi-Friends/m-p/678352#M1084483 ashfaq_haseeb 2014-06-30T11:04:14Z Re: Hi Friends https://community.qlik.com/t5/QlikView/Hi-Friends/m-p/678353#M1084484 <HTML><HEAD></HEAD><BODY><P>Try the bellow thing</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 384px;"><TBODY><TR><TD class="xl63" height="20" width="67">DateField</TD><TD class="xl63" style="border-left: none;" width="317">Function</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">41003</TD><TD class="xl63" style="border-top: none; border-left: none;">Year(DateField)</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">20120404</TD><TD class="xl63" style="border-top: none; border-left: none;">Year( Date#(DateField, 'M/D/YY'), 'YYYY-MM-DD')</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 30 Jun 2014 11:08:33 GMT https://community.qlik.com/t5/QlikView/Hi-Friends/m-p/678353#M1084484 PradeepReddy 2014-06-30T11:08:33Z Re: Hi Friends https://community.qlik.com/t5/QlikView/Hi-Friends/m-p/678354#M1084485 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>If you have year in format 10052007 and you just want to get year</P><P>then you can use</P><P></P><P>right(datefield,4) as Year</P><P>this will give you 2007</P><P></P><P>and if you have year in format</P><P>20070531</P><P>then you can use</P><P>left(datefield,4) as Year</P><P></P><P>thanks</P><P>sudhanshu shrivas</P></BODY></HTML> Mon, 30 Jun 2014 11:21:05 GMT https://community.qlik.com/t5/QlikView/Hi-Friends/m-p/678354#M1084485 2014-06-30T11:21:05Z