https://community.qlik.com/t5/QlikView/Date-format/m-p/1680220#M450008 <P>Hi,</P><P>attached</P><LI-CODE lang="python">Date(Date#(Wrong,'MM/DD/00YY'),'MM/DD/YYYY') as Correct</LI-CODE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 302px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/29289iF80CC89F07013653/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Fri, 28 Feb 2020 08:53:47 GMT Taoufiq_Zarra 2020-02-28T08:53:47Z https://community.qlik.com/t5/QlikView/Date-format/m-p/1680189#M450005 <P>Hi Friends,</P><P>I have some dates entered in wrong&nbsp; with wrong year in my data set as shown below</P><TABLE width="147"><TBODY><TR><TD width="83">Wrong</TD><TD width="64">Correct</TD></TR><TR><TD>2/12/0020</TD><TD>2/12/2020</TD></TR><TR><TD>1/29/0020</TD><TD>1/29/2020</TD></TR><TR><TD>2/10/0020</TD><TD>2/10/2020</TD></TR><TR><TD>1/27/0020</TD><TD>1/27/2020</TD></TR><TR><TD>2/5/0020&nbsp;</TD><TD>2/5/2020</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to change the year 0020 to 2020 in my all date fields while loading the data . Kindly help me with how to write the data load&nbsp; script it please.</P> Fri, 28 Feb 2020 07:42:19 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/1680189#M450005 upaliwije 2020-02-28T07:42:19Z https://community.qlik.com/t5/QlikView/Date-format/m-p/1680220#M450008 <P>Hi,</P><P>attached</P><LI-CODE lang="python">Date(Date#(Wrong,'MM/DD/00YY'),'MM/DD/YYYY') as Correct</LI-CODE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 302px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/29289iF80CC89F07013653/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Fri, 28 Feb 2020 08:53:47 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/1680220#M450008 Taoufiq_Zarra 2020-02-28T08:53:47Z