Date shows as 1900

[cbaqir]

This date field works fine everywhere else but in this new chart, it shows as 1900. I added date#() in the script but it didn't fix it.

Script:

date("ADJ_GOVERNANCE_PHASE_START_DATE", 'MM/DD/YYYY') as ADJ_GOVERNANCE_PHASE_START_DATE,

Dashboard displays all as 1900

Chart Dimensions: (ADJ_GOVERNANCE_PHASE_START_DATE)

Chart expression: if(isnull(ADJ_GOVERNANCE_PHASE_END_DATE),ADJ_GOVERNANCE_PHASE_START_DATE-date(today()),ADJ_GOVERNANCE_PHASE_TAT)

[Kushal_Chawda]

@cbaqir  What is the requirement of chart? Because in expression and dimension both place you have used that Date which is causing that issue. 

[cbaqir]

Please see this post: https://community.qlik.com/t5/QlikView-Creating-Analytics/Ticket-Path-Date-Format-and-Calculation/m-...