Calculating dates using the Calculation.

Follow

Maria Roberts

• December 11, 2015 16:22

Does anyone know how to calculate dates using "Calculation". I need to set a time line for when some activities need to happen. ie. 80 days from 12/15/15 or need it to calculate 1/5/16 - 80 days. Any ideas?

0

• 

  Rainer Grabowski

  • December 11, 2015 20:38

  Hi Maria,

  if you have your dates (12/15/15 or 1/5/16) in date fields you can use this in a calculation field:

  moment(@YourDateField).add(80,"days").toDate()
  

  respectively subtract(80,"days")

  Rainer

  0

  Comment actions Permalink
• 

  Maria Roberts

  • December 11, 2015 22:04

  Not sure if I understand. Could you actually give me an example.
  
  I have in the field:1/16/2016 and I would like to calculate the date that would be 80 days prior to that date. If I calculate it by hand it should be 10/28/15, but I am not getting that when I calculate in Podio. Thank you.

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • December 13, 2015 19:15

  Hi Maria,

  example you have a date field named "Start" with the date 1/16/2016. In the calculation field you have to enter:

  moment(@Start).subtract(80,"days").toDate()
  

  The result is 10/28/2015, it's shown in date format (= looks like a date field).

  Hope that helps
  Rainer

  0

  Comment actions Permalink

Please sign in to leave a comment.