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

Techy007
Techy007
in Dataflows

Best Answer

  • Valiant
    Valiant 🔵
    Accepted Answer

    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.

Answers

  • AS
    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
    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.

  • Techy007
    Techy007

    Thank you! it just works fine ?

  • AS
    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?

Categories