Calculate # of Months between 2 dates

Follow

Scott Anderson

• August 07, 2015 20:21

Does anyone have this calculation they can share with me?

Example 1:
Start Date: 1-1-2015
End Date: 12-31-2015
Calculated # of months should equal: "12.00"

Example 2:
Start Date: 1-1-2015
End Date: 1-15-2015
Calculated # of months should equal: "0.5"

I have seen lots of calculations on Podio Help that I have tried to modify - but they have all ended up being inaccurate to some degree or another. Any help would be really great. Thanks.

0

• 

  Rainer Grabowski

  • August 09, 2015 10:08

  Hi Scott, this should work:

  var start = @start date;
  var end = @end date;
  
  var diffMS = end.diff(start)  // difference in milliseconds;
  var diffDur = moment.duration(diffMS);
  var diffMonth = Math.round(diffDur.asMonths()*10)/10;
  diffMonth
  

  Results for your examples: 12.00 and 0.50

  Rainer
  rg@delos-consulting.com

  0

  Comment actions Permalink
• 

  Mitchell Ogden

  • August 09, 2015 18:41

  @Rainer

  Your Solution failed to work for me... Podio comes back with "Script error: TypeError: undefined is not a function"
  var pick = @Actual Pick Date/Time;
  var drop = @Actual Drop Date/Time;
  var diffMS = drop.diff(pick);
  var diffDur = moment.duration(diffMS);
  diffDur

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • August 09, 2015 18:47

  Sorry, a mistake on my part. Start and end must also be "moments".

  Here's the right solution:

  var start = moment(@start date);
  var end = moment(@end date);
  
  var diffMS = end.diff(start)  // difference in milliseconds;
  var diffDur = moment.duration(diffMS);
  var diffMonth = Math.round(diffDur.asMonths()*10)/10;
  diffMonth
  

  Rainer

  0

  Comment actions Permalink
• 

  Mitchell Ogden

  • August 09, 2015 18:52

  This was my working solution for my use case:

  var start = moment(@Actual Pick Date/Time);
  var end = moment(@Actual Drop Date/Time);

  var diffMS = end.diff(start) // difference in milliseconds;
  var diffDur = moment.duration(diffMS);
  var diffDay = Math.round(diffDur.asDays()*10)/10;
  diffDay + " day(s)"

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • August 09, 2015 18:58

  Mitchell,

  simply:
  var start = moment(@start date);
  var end = moment(@end date);

   end.diff(start,"days")
  

  or more exactly: use my other calculation, but instead of "asMonths" enter "asDays".

  Rainer

  0

  Comment actions Permalink
• 

  Mitchell Ogden

  • August 09, 2015 19:01

  Thanks for the simplification @Rainer !!!

  Mitch

  0

  Comment actions Permalink
• 

  Mitchell Ogden

  • August 10, 2015 01:44

  @Rainer

  Could you take a look at the following question I have?

  https://help.podio.com/hc/communities/public/questions/204618718-Using-a-contains-function-in-conjunction-with-a-switch-case

  0

  Comment actions Permalink
• 

  Scott Anderson

  • August 10, 2015 15:43

  Hello Rainer, Thanks for your efforts. I tried your 'right solution' version that you posted. It sort of works...

  If the Start Date is 8-1-2015, and the end date is 12-31-2015 - the calculated answer comes up as "5.10". I would have expected "5".

  If I the Start Date is 02-01-2015 and the end date is 12-31-2015 - the answer is "11.10".. so something is off.

  Any thoughts on how to fix? Thanks Rainer.

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • August 10, 2015 17:12

  Scott , it's a pain to get the right number for months cause a month's length is defined "30 Days".

  This would show you 5 for 8/12015 - 12/15/2015

  var start = @start date;
  var end = @end date;

  var diffMS = end.diff(start) // difference in milliseconds;
  var diffDur = moment.duration(diffMS);
  var diffMonth = Math.round(diffDur.asMonths());
  diffMonth

  But it would you show "5" also for 8/12015 - 12/15/2015 and 8/12015 - 12/25/2015
  and "4" for 8/12015 - 12/5/2015

  What would you expect for:
  a) 8/12015 - 12/15/2015
  b) 8/12015 - 12/5/2015
  c) 8/12015 - 12/25/2015
  ?

  0

  Comment actions Permalink
• 

  Scott Anderson

  • August 10, 2015 18:21

  Thanks Rainer. I knew dates were tricky but thought someone would have worked something out to address the problem.

  I actually tried your last calc but Podio gave me "Script Error; Type Error; undefined is not a function". ??

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • August 10, 2015 18:27

  Always the same mistake, shouldn't only coypy & paste. Start and end must also be "moments".:

  var start = moment(@start date);
  var end = moment(@end date);

  0

  Comment actions Permalink
• 

  Scott Anderson

  • August 10, 2015 20:58

  I am the king of Copy/Paste. :-)

  Thanks for the clarification... I will try it out.

  0

  Comment actions Permalink
• 

  James Bowie

  • August 25, 2015 01:24

  What about if you have a contract that starts on a date and expires 180 days from the start date, and you want the calculation field to tell you what the date of expiration is?

  Expressed like this:

  var1=(@start_date)
  var2=(@duration_days)

  result = Date of expiration

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • August 25, 2015 05:09

  Hi James,

  var date  = @startdate ;
  var durD = @durationdays;
  
  moment(date).add(durD,'days').toDate()
  

  One tip: Numbers are not allowed as first characters in var names. So can't do var = 1 or var var = 1a, but var = a1.

  Rainer

  0

  Comment actions Permalink
• 

  James Bowie

  • August 25, 2015 06:47

  Rainer, thank you very much!

  Strangely, I used the formula and input 180 days with June 8, 2015 as the start date and it returned: April 5, 2027

  screenshot: https://www.dropbox.com/s/v5l8yo94fwcggs4/closed-loans.jpg?dl=0

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • August 25, 2015 10:47

  Values from a duration field are always given back as hours. So it calculates var durD = 180*24.
  Change var durD to : @duration/24

  0

  Comment actions Permalink
• 

  Scott Anderson

  • August 22, 2018 19:52

  @Rainer - I need to calculate a slightly different version of this and was hoping you could help as I've pulled out all my hair!  I need to calculate the # of days between a field (@.Last Update) and Today's actual date. 

  This is what I have, based on this post, but I really need to replace the field @.CreateDate with today's actual date.  Any thoughts on how to accomplish this??  Thank you.

   

  var start = moment(@.Last Update);
  var end = moment(@.Create Date);

  var diffMS = end.diff(start) // difference in milliseconds;
  var diffDur = moment.duration(diffMS);
  var diffDay = Math.round(diffDur.asDays()*10)/10;
  diffDay + " day(s)"

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • August 24, 2018 10:31

  Hi Scott,
  
  for the "today" problem see my comment here https://help.podio.com/hc/en-us/community/posts/115000113951-Trying-return-a-number-on-subtracting-today-s-date-from-a-given-date-in-a-field-?page=1#community_comment_115000105451
  
  Rainer

  0

  Comment actions Permalink
• 

  Scott Anderson

  • August 24, 2018 16:10

  Thanks Rainer, I will check it out.  Much appreciated!  Have a great day!

  0

  Comment actions Permalink

Please sign in to leave a comment.