https://community.qlik.com/t5/App-Development/Date-picker-not-recognizing-date-when-date-value-coming-greater/m-p/2516463#M105800 <P class="">Hi <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/294149">@nidheesh</a>,<BR />This sounds like a known limitation related to the <STRONG>underlying date serial number range</STRONG> in Qlik. Dates beyond January 18, 2080, may exceed the max serial date Qlik supports (usually tied to the 5-digit serial date limit from Excel-style systems).</P><P class="">A few things you could try:</P><UL><LI><P class=""><STRONG>Ensure your field is interpreted as a date</STRONG> using Date(Date#(FieldName, 'DD/MM/YYYY'))</P></LI><LI><P class="">Use <STRONG>dual()</STRONG> if you need to force Qlik to store a number representation manually.</P></LI><LI><P class="">If it’s just for display (not calculation), consider treating the field as a string.</P></LI></UL><P class="">Hope it's help</P><P class="">Nevo</P> Fri, 02 May 2025 03:58:17 GMT nevopotokcloudinary 2025-05-02T03:58:17Z https://community.qlik.com/t5/App-Development/Date-picker-not-recognizing-date-when-date-value-coming-greater/m-p/2516416#M105791 <P>Date picker not recognizing date -when date value coming greater than 18/Jan/2080</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nidheesh_0-1746101656176.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/180135i79B273B1F6E03BDE/image-size/medium?v=v2&amp;px=400" role="button" title="nidheesh_0-1746101656176.png" alt="nidheesh_0-1746101656176.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nidheesh_1-1746101753882.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/180136i82155F11D24723BB/image-size/medium?v=v2&amp;px=400" role="button" title="nidheesh_1-1746101753882.png" alt="nidheesh_1-1746101753882.png" /></span></P><P>&nbsp;</P> Thu, 01 May 2025 12:16:01 GMT https://community.qlik.com/t5/App-Development/Date-picker-not-recognizing-date-when-date-value-coming-greater/m-p/2516416#M105791 nidheesh 2025-05-01T12:16:01Z https://community.qlik.com/t5/App-Development/Date-picker-not-recognizing-date-when-date-value-coming-greater/m-p/2516463#M105800 <P class="">Hi <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/294149">@nidheesh</a>,<BR />This sounds like a known limitation related to the <STRONG>underlying date serial number range</STRONG> in Qlik. Dates beyond January 18, 2080, may exceed the max serial date Qlik supports (usually tied to the 5-digit serial date limit from Excel-style systems).</P><P class="">A few things you could try:</P><UL><LI><P class=""><STRONG>Ensure your field is interpreted as a date</STRONG> using Date(Date#(FieldName, 'DD/MM/YYYY'))</P></LI><LI><P class="">Use <STRONG>dual()</STRONG> if you need to force Qlik to store a number representation manually.</P></LI><LI><P class="">If it’s just for display (not calculation), consider treating the field as a string.</P></LI></UL><P class="">Hope it's help</P><P class="">Nevo</P> Fri, 02 May 2025 03:58:17 GMT https://community.qlik.com/t5/App-Development/Date-picker-not-recognizing-date-when-date-value-coming-greater/m-p/2516463#M105800 nevopotokcloudinary 2025-05-02T03:58:17Z https://community.qlik.com/t5/App-Development/Date-picker-not-recognizing-date-when-date-value-coming-greater/m-p/2522664#M106692 <P>ok thank you</P><P>&nbsp;</P> Mon, 30 Jun 2025 06:23:39 GMT https://community.qlik.com/t5/App-Development/Date-picker-not-recognizing-date-when-date-value-coming-greater/m-p/2522664#M106692 nidheesh 2025-06-30T06:23:39Z