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

Techy007

Valiant

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

 

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

AS

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?

Techy007

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.

Valiant

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

 

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

Techy007

Thank you! it just works fine ?

AS

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?