# What is the correct way to setup a calculated field for a flag within 2 weeks of a date field? **URL:** \ **Category:** Q&A\ **Tags:** calculations, Business-Intelligence-Engineer, quick-sight\ **Created:** [July 16, 2026, 3:31pm UTC](https://community.amazonquick.com/t/what-is-the-correct-way-to-setup-a-calculated-field-for-a-flag-within-2-weeks-of-a-date-field/53073 "2026-07-16T15:31:45Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![jennifer.dankovic](https://avatars.discourse-cdn.com/v4/letter/j/f475e1/32.png) [@jennifer.dankovic](https://community.amazonquick.com/u/jennifer.dankovic)\ **Post date:** [July 16, 2026, 3:31pm UTC](https://community.amazonquick.com/t/what-is-the-correct-way-to-setup-a-calculated-field-for-a-flag-within-2-weeks-of-a-date-field/53073/1 "2026-07-16T15:31:45Z")
What is the correct way to setup a calculated field for a flag within 2 weeks of a date field? ---
**Author:** ![DylanMorozowski](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/dylanmorozowski/32/33997_2.png) [@DylanMorozowski](https://community.amazonquick.com/u/DylanMorozowski)\ **Post date:** [July 16, 2026, 3:34pm UTC](https://community.amazonquick.com/t/what-is-the-correct-way-to-setup-a-calculated-field-for-a-flag-within-2-weeks-of-a-date-field/53073/2 "2026-07-16T15:34:50Z")
Hello @jennifer.dankovic, just to clarify, do you want a calculated field to return all values from the selected date to 2 weeks after that date? I just want to make sure I am understanding your expectations here! ---
**Author:** ![DylanMorozowski](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/dylanmorozowski/32/33997_2.png) [@DylanMorozowski](https://community.amazonquick.com/u/DylanMorozowski)\ **Post date:** [July 16, 2026, 3:43pm UTC](https://community.amazonquick.com/t/what-is-the-correct-way-to-setup-a-calculated-field-for-a-flag-within-2-weeks-of-a-date-field/53073/3 "2026-07-16T15:43:46Z")
@jennifer.dankovic, my demo dataset is a little old and there are not any dates for 2026, but I built a calculated field in Arena to share with you: [2 Weeks from Date](https://community.amazonquick.com#Arena-dashboardId=a538007d-ad9c-48f7-90a7-78f30254dc6b&authorId=CU-28875) If you view the analysis, and select the table visual, you can see the Date Filter calculated field and filter that I applied. It will use my calculation to determine the values to show, rather than filtering directly on the parameter value. Let me know if this helps! ---
**Author:** ![WLS-Cesar](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-cesar/32/36721_2.png) [@WLS-Cesar](https://community.amazonquick.com/u/WLS-Cesar)\ **Post date:** [August 3, 2026, 3:08pm UTC](https://community.amazonquick.com/t/what-is-the-correct-way-to-setup-a-calculated-field-for-a-flag-within-2-weeks-of-a-date-field/53073/4 "2026-08-03T15:08:17Z")
Hi @jennifer.dankovic, Hope everything is well with you! Just checking back in since this thread hasn’t received a response in a while. Was the reply above helpful to you or were you able to find a solution yourself in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days! ---
**Author:** ![WLS-Cesar](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-cesar/32/36721_2.png) [@WLS-Cesar](https://community.amazonquick.com/u/WLS-Cesar)\ **Post date:** [August 6, 2026, 9:08pm UTC](https://community.amazonquick.com/t/what-is-the-correct-way-to-setup-a-calculated-field-for-a-flag-within-2-weeks-of-a-date-field/53073/5 "2026-08-06T21:08:49Z")
Hi @jennifer.dankovic, Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context. Thank you.