Hi @nidheesh, This sounds like a known limitation related to the underlying date serial number range 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).
A few things you could try:
Ensure your field is interpreted as a date using Date(Date#(FieldName, 'DD/MM/YYYY'))
Use dual() if you need to force Qlik to store a number representation manually.
If it’s just for display (not calculation), consider treating the field as a string.
