Skip to content

    • Magic ETL

    Magic ETL

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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Domo Employee
      Answer ✓

      Here's a beastmode to calculate the difference in months

       

      1. 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

    • Coach

      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"
    • Member

      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.

    • Domo Employee
      Answer ✓

      Here's a beastmode to calculate the difference in months

       

      1. 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.

    • Member

      Thank you! it just works fine ?

    • Coach

      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"

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories