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.
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)
What's the output in ADJ_GOVERNANCE_PHASE_START_DATE? You need to ensure it hold a date value.
You are saying that you are using date#(), but your definition is written without #.
Try this to verify that your field is a date.
Date (date#("ADJ_GOVERNANCE_PHASE_START_DATE", 'MM/DD/YYYY')) as ADJ_GOVERNANCE_PHASE_START_DATE,