web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to get the amount ...

Small and medium business | Business Central, N...

Answered

How to get the amount of months between 2 dates?

(0) Share

Report

Report

Posted on by InsertX

450

Hi,

I know that you can get the amount of days between 2 dates by declaring an integer variable and simply do:

IntVar := DateRecent - DatePast;

Now i was wondering if there also is a way to do this in a way for monts instead of having to calculate with the days since there are months with 28, 30 and 31 dates.

Thanks in advance

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Stefano Demiliani 37,172 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You can use the Date table and filter accordingly.

Maybe something like:

IF (FromDate <> 0D) and (ToDate > FromDate) THEN BEGIN

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

Date.SETRANGE("Period Start",FromDate,ToDate);

Months := Date.COUNT;

END ELSE

Months := 0;

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 626 Super User 2026 Season 2

#2

YUN ZHU 425 Super User 2026 Season 2

#3

Grigorios Mavrogeorgis 384 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans