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)

Salba Z.K 151 on at

Like (0)

Report

RE: Calculate number of month between two dates

Thanks, it worked

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 90,553 Super User 2025 Season 2 on at

Like (1)

Report

RE: Calculate number of month between two dates

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

RE: Calculate number of month between two dates

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

Was this reply helpful? Yes No
Netjacker2097 286 on at

Like (0)

Report

RE: Calculate number of month between two dates

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
Suggested answer

NavNab 6 on at

Like (0)

Report

RE: Calculate number of month between two dates

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

RE: Calculate number of month between two dates

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

Mehdi26 453 on at

Like (0)

Report
RE: Calculate number of month between two dates

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
Verified answer

YUN ZHU 90,553 Super User 2025 Season 2 on at

Like (3)

Report
RE: Calculate number of month between two dates

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
JAngle 113 on at

Like (0)

Report

RE: Calculate number of month between two dates

Does that assume it’s the same year?

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

RE: Calculate number of month between two dates

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