# Issues in custom calculated field related to date

**URL:** <https://community.amazonquick.com/t/issues-in-custom-calculated-field-related-to-date/22223>\
**Category:** Q&A\
**Tags:** error, admin, quick-sight\
**Created:** [December 4, 2023, 4:43pm UTC](https://community.amazonquick.com/t/issues-in-custom-calculated-field-related-to-date/22223 "2023-12-04T16:43:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Annab](https://avatars.discourse-cdn.com/v4/letter/a/2bfe46/32.png) [@Annab](https://community.amazonquick.com/u/Annab)\
**Post date:** [December 4, 2023, 4:43pm UTC](https://community.amazonquick.com/t/issues-in-custom-calculated-field-related-to-date/22223/1 "2023-12-04T16:43:41Z")

</div>

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](https://d1wl4jav5dp96l.cloudfront.net/original/2X/6/6eb7fd7c8022393da11be17a9b78c3c06ab09c05.png)

I would really appriciate some help

---

<div class="post-metadata">

**Author:** ![AnwarAli](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/anwarali/32/3152_2.png) [@AnwarAli](https://community.amazonquick.com/u/AnwarAli)\
**Post date:** [December 4, 2023, 6:32pm UTC](https://community.amazonquick.com/t/issues-in-custom-calculated-field-related-to-date/22223/2 "2023-12-04T18:32:42Z")

</div>

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 Quick Sight Arena. [QuickSight Arena -- An embedded instance of QuickSight within the Community](https://community.amazonquick.com/t/new-quicksight-arena-an-embedded-instance-of-quicksight-within-the-quicksight-community/21437)

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

---

<div class="post-metadata">

**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\
**Post date:** [December 4, 2023, 9:16pm UTC](https://community.amazonquick.com/t/issues-in-custom-calculated-field-related-to-date/22223/3 "2023-12-04T21:16:46Z")

</div>

Hi @Annab  
is the created date = “Status\_change\_date\_time\_\_c\_his”?  
BR

---

<div class="post-metadata">

**Author:** ![Annab](https://avatars.discourse-cdn.com/v4/letter/a/2bfe46/32.png) [@Annab](https://community.amazonquick.com/u/Annab)\
**Post date:** [December 4, 2023, 11:54pm UTC](https://community.amazonquick.com/t/issues-in-custom-calculated-field-related-to-date/22223/4 "2023-12-04T23:54:31Z")

</div>

@ErikG

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