topic Date conversion Jan 2018 to 2018-01-01 in App Development https://community.qlik.com/t5/App-Development/Date-conversion-Jan-2018-to-2018-01-01/m-p/1401498#M32604 <HTML><HEAD></HEAD><BODY><P>Hi I have a Field in my data that is populated by Jan 18, as the Month and Year. </P><P></P><P>Is there any way to convert it into 'yyyy MM dd' ? </P><P></P><P>I have looked at inline tables but there are to many variables. </P><P></P><P>Many Thanks </P></BODY></HTML> Thu, 30 Nov 2017 05:53:59 GMT mikegauntlett 2017-11-30T05:53:59Z Date conversion Jan 2018 to 2018-01-01 https://community.qlik.com/t5/App-Development/Date-conversion-Jan-2018-to-2018-01-01/m-p/1401498#M32604 <HTML><HEAD></HEAD><BODY><P>Hi I have a Field in my data that is populated by Jan 18, as the Month and Year. </P><P></P><P>Is there any way to convert it into 'yyyy MM dd' ? </P><P></P><P>I have looked at inline tables but there are to many variables. </P><P></P><P>Many Thanks </P></BODY></HTML> Thu, 30 Nov 2017 05:53:59 GMT https://community.qlik.com/t5/App-Development/Date-conversion-Jan-2018-to-2018-01-01/m-p/1401498#M32604 mikegauntlett 2017-11-30T05:53:59Z Re: Date conversion Jan 2018 to 2018-01-01 https://community.qlik.com/t5/App-Development/Date-conversion-Jan-2018-to-2018-01-01/m-p/1401499#M32605 <HTML><HEAD></HEAD><BODY><P>Hello, maybe this in the script:</P><P></P><PRE __default_attr="xml" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15120701590766990 jive_text_macro" jivemacro_uid="_15120701590766990" modifiedtitle="true"> <P>Date(Date#(YourDateField, 'MMM YYYY'), 'YYYY.MM.DD') AS YourDateField</P> </PRE></BODY></HTML> Thu, 30 Nov 2017 19:30:31 GMT https://community.qlik.com/t5/App-Development/Date-conversion-Jan-2018-to-2018-01-01/m-p/1401499#M32605 Ivan_Bozov 2017-11-30T19:30:31Z Re: Date conversion Jan 2018 to 2018-01-01 https://community.qlik.com/t5/App-Development/Date-conversion-Jan-2018-to-2018-01-01/m-p/1401500#M32606 <HTML><HEAD></HEAD><BODY><P>Also, look at these threads</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/qlik-blogpost/2622">Get the Dates Right</A></P></BODY></HTML> Thu, 30 Nov 2017 19:47:20 GMT https://community.qlik.com/t5/App-Development/Date-conversion-Jan-2018-to-2018-01-01/m-p/1401500#M32606 sunny_talwar 2017-11-30T19:47:20Z Re: Date conversion Jan 2018 to 2018-01-01 https://community.qlik.com/t5/App-Development/Date-conversion-Jan-2018-to-2018-01-01/m-p/1401501#M32607 <HTML><HEAD></HEAD><BODY><P>Try Date(Date#(YourDateField, 'MMM YYYY'), 'YYYY-MM-DD')</P></BODY></HTML> Fri, 01 Dec 2017 06:46:26 GMT https://community.qlik.com/t5/App-Development/Date-conversion-Jan-2018-to-2018-01-01/m-p/1401501#M32607 shraddha_g 2017-12-01T06:46:26Z Re: Date conversion Jan 2018 to 2018-01-01 https://community.qlik.com/t5/App-Development/Date-conversion-Jan-2018-to-2018-01-01/m-p/1401502#M32608 <HTML><HEAD></HEAD><BODY><P>Thanks Ivan, that worked </P></BODY></HTML> Tue, 05 Dec 2017 10:04:42 GMT https://community.qlik.com/t5/App-Development/Date-conversion-Jan-2018-to-2018-01-01/m-p/1401502#M32608 mikegauntlett 2017-12-05T10:04:42Z