topic Re: Can someone help me with this formatting please? in QlikView https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951512#M327244 <HTML><HEAD></HEAD><BODY><P>Thanks everyone for your help and answers, don't know how I didn't get that...I was trying to be too complex!</P></BODY></HTML> Fri, 06 Nov 2015 10:48:19 GMT 2015-11-06T10:48:19Z Can someone help me with this formatting please? https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951504#M327236 <HTML><HEAD></HEAD><BODY><P>Morning all,</P><P></P><P>A date field has changed formats in between one of my IT loads, I need to change the date back to how it was within the script. Can someone help me with the following please?</P><P></P><P>InputDateOriginal&nbsp; 2015-01</P><P>InputDateChanged 05/01/2015</P><P></P><P>I'm getting myself in a bit of a tizz with the syntax and I can't seem to get it right!</P><P></P><P>Any help is appreciated.</P></BODY></HTML> Fri, 06 Nov 2015 10:34:56 GMT https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951504#M327236 2015-11-06T10:34:56Z Re: Can someone help me with this formatting please? https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951505#M327237 <HTML><HEAD></HEAD><BODY><P>use date(InputDateChanged,'YYYY-MM')</P></BODY></HTML> Fri, 06 Nov 2015 10:39:18 GMT https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951505#M327237 Anonymous 2015-11-06T10:39:18Z Re: Can someone help me with this formatting please? https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951506#M327238 <HTML><HEAD></HEAD><BODY><P>you can again change it:</P><P></P><P>=date(YourFieldDate,'YYYY-MM') </P></BODY></HTML> Fri, 06 Nov 2015 10:39:44 GMT https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951506#M327238 Anonymous 2015-11-06T10:39:44Z Re: Can someone help me with this formatting please? https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951507#M327239 <HTML><HEAD></HEAD><BODY><P>I've done that and it seems to work, I then need to split the month so I end up with a single number for the month.</P><P></P><P>e.g. 2015-01 would have a measure month of 1</P><P></P><P>That's the bit I'm struggling with, trying to get a single integer for the month. </P></BODY></HTML> Fri, 06 Nov 2015 10:41:28 GMT https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951507#M327239 2015-11-06T10:41:28Z Re: Can someone help me with this formatting please? https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951508#M327240 <HTML><HEAD></HEAD><BODY><P>Hey Samuel,</P><P></P><P>Try this in the script:</P><P></P><P>Date(Date#([InputDateChanged], 'DD/MM/YYYY'), 'YYYY-MM') as InputDateOriginal</P><P></P><P>Regards,</P><P>MB</P></BODY></HTML> Fri, 06 Nov 2015 10:42:17 GMT https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951508#M327240 miguelbraga 2015-11-06T10:42:17Z Re: Can someone help me with this formatting please? https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951509#M327241 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">month(InputDateChanged</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P></BODY></HTML> Fri, 06 Nov 2015 10:43:03 GMT https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951509#M327241 Anonymous 2015-11-06T10:43:03Z Re: Can someone help me with this formatting please? https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951510#M327242 <HTML><HEAD></HEAD><BODY><P>Check out also this:</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/previewBody/3102-102-3-4191/DateFields-TechBrief-US_v2.pdf">https://community.qlik.com/servlet/JiveServlet/previewBody/3102-102-3-4191/DateFields-TechBrief-US_v2.pdf</A></P><P></P><P>In page 4 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Fri, 06 Nov 2015 10:43:08 GMT https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951510#M327242 miguelbraga 2015-11-06T10:43:08Z Re: Can someone help me with this formatting please? https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951511#M327243 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.qlik.com/qlik-users/139104">FLsamvile18</A>‌,</P><P>try this :</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">mid(Date(Date#([InputDateChanged], 'DD/MM/YYYY'), 'YYYY-MM'),6,7)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">or you can use subfield as well.<BR /></SPAN></P><P></P><P>Thanks,</P><P>Punit</P></BODY></HTML> Fri, 06 Nov 2015 10:45:47 GMT https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951511#M327243 punitpopli 2015-11-06T10:45:47Z Re: Can someone help me with this formatting please? https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951512#M327244 <HTML><HEAD></HEAD><BODY><P>Thanks everyone for your help and answers, don't know how I didn't get that...I was trying to be too complex!</P></BODY></HTML> Fri, 06 Nov 2015 10:48:19 GMT https://community.qlik.com/t5/QlikView/Can-someone-help-me-with-this-formatting-please/m-p/951512#M327244 2015-11-06T10:48:19Z