Date - Year by Year

[Samje (Sam)]

Hi Team,

Could you please suggest a solution followed by Start date and End date as mentioned below

StartDate EndDate

30-09-2025 30-09-2026
30-09-2026 30-09-2027
30-09-2027 30-09-2028
30-09-2028 30-10-2029

30-09-2024 30-09-2025
30-09-2025 30-09-2026
30-09-2026 30-09-2027
30-09-2027 30-08-2028

[Anil_G (Anil Gorthi)]

@Samje

May I know why the last end dates dont follow the year difference

On what basic do we need to do this?

Cheers

[Samje (Sam)]

Hi Anil,

As mentioned earlier, I need a start date (30-09-2025) and an end date (30-10-2029) for each year.

Thanks

[Anil_G (Anil Gorthi)]

@Samje

but end date for first row is not 30-10-2026 but 30-09-2026

cheers

[sudster]

I think the question @Anil_G was asking, what is the logic for start date and end date? Is there a logic to calculate both or is start date given, then calculate the end date? If there’s a calculation, what is it?

[Samje (Sam)]

Hi Sudster,

Please find my response below.

Case 1
If dd-mm of start date is same as dd-mm of end date, bot need to change the year only.
(Year 1) will always be this year despite the given date.

Given date(Input) in Datatable

Expected Output (Date splitted into years)
Start date - End date
30-09-2024 - 30-09-2025 (year 1)
30-09-2025 - 30-09-2026 (year 2)
30-09-2026 - 30-09-2027 (year 3)
30-09-2027 - 30-09-2028 (year 4)
30-09-2028 - 30-09-2029 (year 5)

case 2
dd-mm of start date don’t match with dd-mm of end date, bot need to change the date of the end date of each year and bot need to calculate the remaining months. Eg : below 3 months

Given date(Input) in Datatable

Expected Output (Date splitted into years and months)
Start date - End date
30-09-2024 - 29-09-2025 (year 1)
30-09-2025 - 29-09-2026 (year 2)
30-09-2026 - 29-09-2027 (year 3)
30-09-2027 - 30-12-2027 (3 months)

Thank you

[sudster]