topic Date not pulling through after conversion in QlikView https://community.qlik.com/t5/QlikView/Date-not-pulling-through-after-conversion/m-p/1582653#M443006 <P>Hi</P><P>I have transformed a string data into d date using the <STRONG>Date(Date(SubField(date_time,' ',1),'MM/DD/YYYY'))) &nbsp;</STRONG>conversion. However some of the data is not showing. please see example below.</P><P>What does not makes sense is that I have also extracted the time from the string and it works fine.</P><P>Please assist.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Date and time.PNG" style="width: 436px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/12422iF6CB3D24E21DCB2A/image-size/large?v=v2&amp;px=999" role="button" title="Date and time.PNG" alt="Date and time.PNG" /></span></P><P>Thanks</P> Sat, 16 Nov 2024 20:49:43 GMT skzwane01 2024-11-16T20:49:43Z Date not pulling through after conversion https://community.qlik.com/t5/QlikView/Date-not-pulling-through-after-conversion/m-p/1582653#M443006 <P>Hi</P><P>I have transformed a string data into d date using the <STRONG>Date(Date(SubField(date_time,' ',1),'MM/DD/YYYY'))) &nbsp;</STRONG>conversion. However some of the data is not showing. please see example below.</P><P>What does not makes sense is that I have also extracted the time from the string and it works fine.</P><P>Please assist.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Date and time.PNG" style="width: 436px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/12422iF6CB3D24E21DCB2A/image-size/large?v=v2&amp;px=999" role="button" title="Date and time.PNG" alt="Date and time.PNG" /></span></P><P>Thanks</P> Sat, 16 Nov 2024 20:49:43 GMT https://community.qlik.com/t5/QlikView/Date-not-pulling-through-after-conversion/m-p/1582653#M443006 skzwane01 2024-11-16T20:49:43Z Re: Date not pulling through after conversion https://community.qlik.com/t5/QlikView/Date-not-pulling-through-after-conversion/m-p/1582663#M443007 <P>your date conversion&nbsp;<STRONG>MM/DD/YYYY </STRONG>cannot convert 13/07/2016. 13 is not a valid month<BR />either your date is in format DD/MM/YYYY or your calendar has a special month 13 for<BR />any reason&nbsp;</P> Tue, 21 May 2019 10:48:53 GMT https://community.qlik.com/t5/QlikView/Date-not-pulling-through-after-conversion/m-p/1582663#M443007 Anonymous 2019-05-21T10:48:53Z