# How to find the Difference between Months of two dates. Eg : 01/01/2017(start date) and Curdate.?

⚪️

Here's a beastmode to calculate the difference in months

`period_diff(date_format(`Enddate`, '%Y%m'),date_format(`Startdate`, '%Y%m'))`

Just plug in your own date values and you should be good to go.

Let me know if that wasn't what you were looking for.

Sincerely,

ValiantSpur

**Say "Thanks" by clicking the "heart" in the post that helped you.

• 🔵

There's a beast mode that can do this.

DATEDIFF
Returns the number of days between two dates from datetime values.
DATEDIFF(CURRENT_DATE(), 'lastmoddate')

Is that what you're looking for?

Aaron
MajorDomo @ Merit Medical

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
• Thanks for your reply Aaron, I am looking to calculate age in Months.
Eg: How to calculate the number of months between two Dates.

According to Excel formaule= Datdif(Startdate,Enddate+15,"M"), considering the values mentioned above in the question, expected answer is 14 months difference between date 01/01/2017 to todays date(2/26/2018).

Im looking something similar in DOMO.

• Thank you! it just works fine ?

• 🔵

How do partial months and rounding come in to play for your business?

Is Jan 1 - Feb 28 two months?  What about Jan 15 - Feb 14? One month or two?

What about Jan 31 - Mar 1?  One month or three?

Aaron
MajorDomo @ Merit Medical

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"