# Quick Sight Formula to Split months based on Start Date and End Date

**URL:** <https://community.amazonquick.com/t/quick-sight-formula-to-split-months-based-on-start-date-and-end-date/46529>\
**Category:** Q&A\
**Tags:** error, developer, quick-sight\
**Created:** [May 23, 2025, 2:49am UTC](https://community.amazonquick.com/t/quick-sight-formula-to-split-months-based-on-start-date-and-end-date/46529 "2025-05-23T02:49:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Meena1](https://avatars.discourse-cdn.com/v4/letter/m/90db22/32.png) [@Meena1](https://community.amazonquick.com/u/Meena1)\
**Post date:** [May 23, 2025, 2:49am UTC](https://community.amazonquick.com/t/quick-sight-formula-to-split-months-based-on-start-date-and-end-date/46529/1 "2025-05-23T02:49:21Z")

</div>

Hi Team,

Kindly help to give suggestions as I have a column start date, End Date, Monthly Rate which is coming from the database table from which i want to derive the columns Jan25,Feb25,Mar25,Apr25. These columns should come dynamically based on start date and enddate along with year mentioned.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/0/e/0e1d368a9c8aa0b4cea223f5569db8788d3f223d.png)

---

<div class="post-metadata">

**Author:** ![Giridhar.Prabhu](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/giridhar.prabhu/32/27789_2.png) [@Giridhar.Prabhu](https://community.amazonquick.com/u/Giridhar.Prabhu)\
**Post date:** [May 23, 2025, 4:31am UTC](https://community.amazonquick.com/t/quick-sight-formula-to-split-months-based-on-start-date-and-end-date/46529/2 "2025-05-23T04:31:11Z")

</div>

Hi @Meena1

I see a problem with your requirement. Creating it dynamically is one thing, but each field requires an identifier and if that is dynamic any downstream usage is not possible.

What exactly are you trying to achieve with these dynamic columns? You can given one row as example from your table, what if each row has different start and end dates with different ranges?

Regards,  
Giri

Regards,  
Giri

---

<div class="post-metadata">

**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\
**Post date:** [June 2, 2025, 2:33pm UTC](https://community.amazonquick.com/t/quick-sight-formula-to-split-months-based-on-start-date-and-end-date/46529/3 "2025-06-02T14:33:15Z")

</div>

Hello @Meena1

Are you able to follow up on @Giridhar.Prabhu 's question or were you able to solve this? If we do not hear back from you in two business days this topic will be archived.

---

<div class="post-metadata">

**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\
**Post date:** [June 5, 2025, 3:02pm UTC](https://community.amazonquick.com/t/quick-sight-formula-to-split-months-based-on-start-date-and-end-date/46529/4 "2025-06-05T15:02:53Z")

</div>