Date Calculations

Completed
Follow
Olivier Suc

How can I add a number of days to a date field? I can't seem to be able to do that in the Calculation block I add to an app. I basically want to add the expected payment date to an invoice based on when the invoice is sent to the customer. So if I send the invoice on 1/1/2014 and the customer is on a net 30 day for payment I'd like to have a new field with 2/1/2014 for the expected payment date.
Thank you

0

Comments

14 comments

Date Votes
  • Official comment
    Sara Høeg Højlund-Rasmussen

    Thanks for the update Oliver, you're right that the option is now available using the updated Calculation field :)

    You'll need a few skills with JavaScript to make it work but it is possible.

    We created this Forum in case you need help using the new calculation / JavaScript field:
    https://help.podio.com/hc/communities/public/topics/200101427-6-Calculations

    Cheers,
    Sara - Podio

    Comment actions Permalink
  • Sara Høeg Højlund-Rasmussen

    Hey Olivier

    Good question :) Currently it is not possible to calculate based on date fields. You can only calculate based on number, money and duration fields.

    It is a great idea so I will move your question to the "feature request" forum.

    Cheers,
    Sara - Podio

    0
    Comment actions Permalink
  • Kelsey Kleiman

    We too would love to have this feature. Is it on the horizon?

    0
    Comment actions Permalink
  • Olivier Suc

    @ Kelsey. Take a look at this thread for more information on what can be done with Javascript. https://help.podio.com/hc/en-us/articles/201019358-Calculations. It is not perfect but it may help while that feature is developed.

    0
    Comment actions Permalink
  • Marcelo Vital Brazil

    I believe what you need can be done with javascript such as:

    moment(@Intial Date).add('days', @Num of days).format("DD/MM/YYYY")

    0
    Comment actions Permalink
  • Dan Stroehlein

    Any code to add 3 hours to a date&time to come up with a date&time that can be used in a workflow?? I can add dates and it works but cannot add hours. Any ideas please help!!

    0
    Comment actions Permalink
  • Dan Stroehlein

    Figured it out... @ON the Ground Time.setHours(@ON the Ground Time.getHours() + 3);@ON the Ground Time

    1
    Comment actions Permalink
  • Kelly Singleton

    I'm attempting to create nearly the same javascript calculation. I have no javascript experience... I have copy/pasted the samples given by Marcelo and Dan into a calculation box and I get this error:

    The calculation field must reference at least one other field. It cannot be entirely based on static data, such as strings or numbers

    Do I need a moment(@Intial Date or ON the Ground Time.setHours field?

    Thanks for any help.

    0
    Comment actions Permalink
  • Dan Stroehlein

    Kelly - The @Dates are the same date field that you want to add the hours to which in my case is the 3.

    0
    Comment actions Permalink
  • Kelly Singleton

    Here's exactly what I'm trying to do:

    When I add a new lead in the app and change a certain field I want a task to appear for 30 days out. Are you saying that I'll have to a date block in the app? I will have to manually insert today's date correct? Is there any way to get around manually setting that date block? The calculation I need will always reference the date the lead was created...

    0
    Comment actions Permalink
  • Sara Høeg Højlund-Rasmussen

    Kelly, what you describe is possible using the advanced workflows: https://help.podio.com/hc/en-us/articles/204366037-Advanced-workflows

    You can trigger a task to be created +30 days in the future :)

    //Sara - Podio

    0
    Comment actions Permalink
  • Dan Stroehlein

    Sara,

    Any plans to allow calculated dates and times for use in setting workflow tasks?

    0
    Comment actions Permalink
  • Sara Høeg Højlund-Rasmussen

    No plans so far - but we just added the option to set a date field +/- x days from a date field in the workflows :)

    Perhaps this is what you need?

    //Sara - Podio

    0
    Comment actions Permalink
  • Kelly Singleton

    I was able to have a hidden date block for that day created upon lead creation. Then when I change a certain field in that lead it triggers a task a certain number of days from that date. Works great. Thanks Sara.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post
Powered by Zendesk