# Discovering final date given an initial date and quantity of days **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Natural, natural-mainframe\ **Created:** [November 4, 2022, 1:22pm UTC](https://techcommunity.softwareag.com/t/discovering-final-date-given-an-initial-date-and-quantity-of-days/265591 "2022-11-04T13:22:21Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Priscilla\_G\_Souza](https://avatars.discourse-cdn.com/v4/letter/p/c4cdca/32.png) [@Priscilla\_G\_Souza](https://techcommunity.softwareag.com/u/Priscilla_G_Souza)\ **Post date:** [November 4, 2022, 1:22pm UTC](https://techcommunity.softwareag.com/t/discovering-final-date-given-an-initial-date-and-quantity-of-days/265591/1 "2022-11-04T13:22:21Z")
#### Hi! Is it possible to obtain the end date given a start date and a number of days? And vice versa: get a start date giving an end date and an amount of days? PS: dates are in numeric format (N08) in this sequence YYYYMMDD. EG: given an initial date 20220606, what’s the date after 100 days? #### I just have no idea how to obtain this.. If anyone can help me, I would be grateful! ---
**Author:** ![Marc](https://avatars.discourse-cdn.com/v4/letter/m/8dc957/32.png) [@Marc](https://techcommunity.softwareag.com/u/Marc)\ **Post date:** [November 4, 2022, 1:39pm UTC](https://techcommunity.softwareag.com/t/discovering-final-date-given-an-initial-date-and-quantity-of-days/265591/2 "2022-11-04T13:39:35Z")
Hi Priscilla, Something like this: DEFINE DATA LOCAL 1 DATE-N (N8) 1 REDEFINE DATE-N 2 DATE-A (A8) 1 DATE (D) END-DEFINE INPUT DATE-N MOVE EDITED DATE-A TO DATE (EM=YYYYMMDD) ADD 100 TO DATE WRITE DATE (EM=DD/MM/YYYY) END ---
**Author:** ![MICK.FITZPATRICK](https://avatars.discourse-cdn.com/v4/letter/m/b5ac83/32.png) [@MICK.FITZPATRICK](https://techcommunity.softwareag.com/u/MICK.FITZPATRICK)\ **Post date:** [November 4, 2022, 1:43pm UTC](https://techcommunity.softwareag.com/t/discovering-final-date-given-an-initial-date-and-quantity-of-days/265591/3 "2022-11-04T13:43:57Z")
Priscilla, You can MOVE EDITED your N8 to a variable define as a “date” – example: 1 #DATE (D) – then ADD 100 to #DATE and finally MOVE EDITED it to the end date ---
**Author:** ![Eugene.Miklovich](https://avatars.discourse-cdn.com/v4/letter/e/ce73a5/32.png) [@Eugene.Miklovich](https://techcommunity.softwareag.com/u/Eugene.Miklovich)\ **Post date:** [November 4, 2022, 2:58pm UTC](https://techcommunity.softwareag.com/t/discovering-final-date-given-an-initial-date-and-quantity-of-days/265591/4 "2022-11-04T14:58:14Z")
P.S. You may have to either: 1. REDEFINE N8 as A8 and MOVE EDITED A8 to Date 2. MOVE N8 to A8 then MOVED edited A8 to Date Then you can add 100 to date field and if you want move EDITED back…. ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [May 3, 2023, 2:58pm UTC](https://techcommunity.softwareag.com/t/discovering-final-date-given-an-initial-date-and-quantity-of-days/265591/5 "2023-05-03T14:58:42Z")
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.