Issues in custom calculated field related to date

Question & Answer
,
1

Hi,

In the analysis I have created the following calculated field:
formatDate(parseDate(ifelse(isNotNull({Status_change_date_time__c_his}) = TRUE, substring({Status_change_date_time__c_his},1,10),“1099-01-01”),‘yyyy-MM-dd’),‘yyyy-MM-dd’)

It applies on most values, but fiew are failung and I do not understand why.
Here is an example of such case:

image
image1174×212 12.8 KB

I would really appriciate some help

2

Hi Annab,

Thanks for posting the question. We may need sample dataset and analysis to help you. Is it possible for you to please provide us sample subset of data and dashboard through QuickSight Arena. NEW -- QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community

Note: As Arena is public website, please don’t upload any sensitive dataset/information. We just need mock data to understand the issue.

Regards,
Anwar Ali

3

Hi @Annab
is the created date = “Status_change_date_time__c_his”?
BR

1 Like
4

@ErikG

Thank you so much!!! This was it.
I missed it al together