# How to add 90 days to the date field

**URL:** <https://community.amazonquick.com/t/how-to-add-90-days-to-the-date-field/18024>\
**Category:** Q&A\
**Tags:** error, calculations, quick-sight\
**Created:** [September 14, 2023, 5:11am UTC](https://community.amazonquick.com/t/how-to-add-90-days-to-the-date-field/18024 "2023-09-14T05:11:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tdr\_Dinesh](https://avatars.discourse-cdn.com/v4/letter/t/e68b1a/32.png) [@tdr\_Dinesh](https://community.amazonquick.com/u/tdr_Dinesh)\
**Post date:** [September 14, 2023, 5:11am UTC](https://community.amazonquick.com/t/how-to-add-90-days-to-the-date-field/18024/1 "2023-09-14T05:11:12Z")

</div>

Hello Team,

Could you please some one assist me on below scenario.

In my dataset, we have a date field named as received date, based on this date filed we need to add the target date to the visualization. Target date = 90 days from the received date. Please assist.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/0/0b5e8ecc7297d29e4d3fa14063e48de2a6044c62.png)

---

<div class="post-metadata">

**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\
**Post date:** [September 14, 2023, 5:20am UTC](https://community.amazonquick.com/t/how-to-add-90-days-to-the-date-field/18024/2 "2023-09-14T05:20:38Z")

</div>

Hi @tdr_Dinesh - Can you please explore the QS function addDateTime for this requirement. Please see the documentation details below.

> **[addDateTime - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/addDateTime-function.html)**
>
> addDateTime adds or subtracts a unit of time from a datetime value. For example, addDateTime(2,'YYYY',parseDate('02-JUL-2018', 'dd-MMM-yyyy') ) returns 02-JUL-2020 . You can use this function to perform date math on your date and time data.

Regards - Sanjeeb

---

<div class="post-metadata">

**Author:** ![tdr\_Dinesh](https://avatars.discourse-cdn.com/v4/letter/t/e68b1a/32.png) [@tdr\_Dinesh](https://community.amazonquick.com/u/tdr_Dinesh)\
**Post date:** [September 14, 2023, 5:38am UTC](https://community.amazonquick.com/t/how-to-add-90-days-to-the-date-field/18024/3 "2023-09-14T05:38:40Z")

</div>

> [@Sanjeeb2022](#):
>
> [addDateTime - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/addDateTime-function.html)

@Sanjeeb2022

Thank you.