Calculate number of month between two dates

(0) Share

Report

Posted on by Mehdi26

453

I want to calculate the number of month between a fromDate and ToDate.

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

Use Date2DMY to get the both month for comparison.

fromMonth := Date2DMY(fromDate,2);

toMonth := Date2DMY(toDate,2);

Diff := toMonth - fromMonth;

Was this reply helpful? Yes No
JAngle 133 on at

Like (0)

Report

Does that assume it’s the same year?

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,640 Super User 2025 Season 2 on at

Like (3)

Report
Hi, as Josh Anglesea said, you should pay attention to different years.

A simple example: for reference only

pageextension 50100 MyExtension extends "Customer List" { trigger OnOpenPage() begin Message('Months between %1 and %2 is %3', 20150101D, Today, CalculateMonthBetweenTwoDate(20150101D, Today)); end; local procedure CalculateMonthBetweenTwoDate(StartDate: Date; EndDate: Date): Integer var NoOfYears: Integer; NoOfMonths: Integer; begin NoOfYears := DATE2DMY(EndDate, 3) - DATE2DMY(StartDate, 3); NoOfMonths := DATE2DMY(EndDate, 2) - DATE2DMY(StartDate, 2); exit(12 * NoOfYears NoOfMonths); end; }

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Mehdi26 453 on at

Like (0)

Report
I did it this way:

Clear(NoOfMonths); NoOfMonths := DATE2DMY("Shipment Date", 2) - DATE2DMY(TODAY, 2) 12 * (DATE2DMY("Shipment Date", 3) - DATE2DMY(TODAY, 3));

But ZHU's answer is also correct.

Was this reply helpful? Yes No
Netjacker2097 286 on at

Like (0)

Report

Hi,

How would you change your sample calculation to suite a service date - next service date = No. of days bitween.

but i need another coloum to show the current no.of days left till next service.

hope it makes sence.

Was this reply helpful? Yes No
Suggested answer

NavNab 6 on at

Like (0)

Report

another suggestion just in case:

Date.Setrange("Period Type", Date."Period Type"::Month);

Date.Setfilter("Period Start", '>=%1&<=%2', StartDate, EndDate);

Message('Months between %1 and %2 is %3', StartDate, EndDate, Date.Count - 1);

Variable >> Date: Record Date

Was this reply helpful? Yes No
Netjacker2097 286 on at

Like (0)

Report

That working as it should, thanks for that ...had to adjust the code slightly to suite my scenario.

Thanks..

Was this reply helpful? Yes No
Salba Z.K 151 on at

Like (0)

Report

How can we calculate days, as number of days are not fixed in year and month?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,640 Super User 2025 Season 2 on at

Like (1)

Report

Hi, The calculation of the number of days only needs to be as follows.

Day := EndDate - StartDate;

Alternatively, you can try table 2000000007 "Date", which can also be calculated.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Salba Z.K 151 on at

Like (0)

Report

Thanks, it worked

Was this reply helpful? Yes No