topic Re: Year only in QlikView https://community.qlik.com/t5/QlikView/Year-only/m-p/51523#M8522 <HTML><HEAD></HEAD><BODY><P>Good readings on this topic</P><P><A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></P><P><A href="https://community.qlik.com/docs/DOC-3102">QlikView Date fields</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P></BODY></HTML> Mon, 19 Mar 2018 18:36:13 GMT sunny_talwar 2018-03-19T18:36:13Z Year only https://community.qlik.com/t5/QlikView/Year-only/m-p/51521#M8520 <HTML><HEAD></HEAD><BODY><P>Can someone please explain why I can't get just the year using this:</P><P></P><P><SPAN style="color: #0000ff; font-size: 12pt;">Year</SPAN><SPAN style="font-size: 12pt;">(<SPAN style="color: #800000;">[Valid Frm Date]</SPAN>) <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">[Valid Year]</SPAN></SPAN><SPAN style="font-size: 12pt;">, my date format is YYYY-MM-DD</SPAN></P></BODY></HTML> Mon, 19 Mar 2018 18:30:05 GMT https://community.qlik.com/t5/QlikView/Year-only/m-p/51521#M8520 tmumaw 2018-03-19T18:30:05Z Re: Year only https://community.qlik.com/t5/QlikView/Year-only/m-p/51522#M8521 <HTML><HEAD></HEAD><BODY><P>One possibility could be that your field has not interpreted as date, you may need to use this - </P><P></P><P><SPAN style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Year</SPAN><SPAN style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">(Date#(<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">[Valid Frm Date],'SourceFieldformat'</SPAN>)) <SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #0000ff;">as</SPAN> <SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">[Valid Year]</SPAN></SPAN><SPAN style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">, my date format is YYYY-MM-DD</SPAN></P><P></P><P>Use 'YYYY-MM-DD' in place of sourcefieldformat if the source data has this format.</P></BODY></HTML> Mon, 19 Mar 2018 18:33:40 GMT https://community.qlik.com/t5/QlikView/Year-only/m-p/51522#M8521 Digvijay_Singh 2018-03-19T18:33:40Z Re: Year only https://community.qlik.com/t5/QlikView/Year-only/m-p/51523#M8522 <HTML><HEAD></HEAD><BODY><P>Good readings on this topic</P><P><A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></P><P><A href="https://community.qlik.com/docs/DOC-3102">QlikView Date fields</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P></BODY></HTML> Mon, 19 Mar 2018 18:36:13 GMT https://community.qlik.com/t5/QlikView/Year-only/m-p/51523#M8522 sunny_talwar 2018-03-19T18:36:13Z Re: Year only https://community.qlik.com/t5/QlikView/Year-only/m-p/51524#M8523 <HTML><HEAD></HEAD><BODY><P>Thanks.&nbsp; Running into a few problems from our upgrade this past weekend.&nbsp; New server, new release of QV 12.20, new SAP Connector......</P></BODY></HTML> Tue, 20 Mar 2018 12:21:47 GMT https://community.qlik.com/t5/QlikView/Year-only/m-p/51524#M8523 tmumaw 2018-03-20T12:21:47Z