Calculating a new date +/- X days

Follow

James Lawler

• June 04, 2014 13:37

Hi

I want to calculate a new date (which I can then use in tasks, in workflow) based on an existing date.

For example:

• Due Date is 31/03/2014 (dd/mm/yyyy)
• I want to automatically set a new date which is 30 days earlier (which would be 01/03/2014)
• I then want to be able to create a task (using workflow) which sets the task due date as the 'new date' field.

The purpose of it is to remind one of our users that an article is due for publication 30 days before the due date.

Thanks

2

• 

  Damir Ayginin

  • June 04, 2014 14:26

  Hi, James.

  I've managed to do this yesterday with

  @Date.setDate(@Date.getDate() - 30);
  @Date;

  But, unfortunately, workflows don't recognize these date fields as the ones we can use as "due" :(

  0

  Comment actions Permalink
• 

  James Lawler

  • June 04, 2014 15:01

  Hi Damir,

  I tried your code but it didn't work.

  Do all 3 '@Date' references reference the same field? In my case 'Publication Date'

  0

  Comment actions Permalink
• 

  Damir Ayginin

  • June 04, 2014 15:21

  Yep, they do reference to the same @publication date.

  Have you tried deleting calculation field and creating a new one?

  0

  Comment actions Permalink
• 

  James Lawler

  • June 04, 2014 16:04

  That sorted it thanks!

  It's a shame you can't use the date within workflow due dates!

  0

  Comment actions Permalink
• 

  Michael Kagan

  • December 14, 2014 06:31

  Hey everyone,

  This thread was most helpful to me (a non-programmer).

  I was trying to increment the date and Damir's code was most helpful. I finally got it to work for me with the following coding (after deleting the calculation field and creating a new one, thanks for that tip as well!):

  var zover = @Start Date
  zover.setDate(@Start Date.getDate() + @Duration);
  zover;

  1

  Comment actions Permalink
• 

  Justin VanDervort

  • July 05, 2018 23:15

  Michael Kagan's response below truly worked for me! I had to add one extra day for some reason, I'm not sure. But this added days to my date and returned a date that podio recognized as a date again!  Here's the exact script I used below with my references and then Michael's post quoted below that. 

  var zover = @Supplement Plan Start Date
  zover.setDate(@Supplement Plan Start Date.getDate() + @[Days of Supply] + 1);
  zover;

   

  Quote:

  "Hey everyone,

  This thread was most helpful to me (a non-programmer).

  I was trying to increment the date and Damir's code was most helpful. I finally got it to work for me with the following coding (after deleting the calculation field and creating a new one, thanks for that tip as well!):

  var zover = @Start Date
  zover.setDate(@Start Date.getDate() + @Duration);
  zover;

  Michael Kagan "

  1

  Comment actions Permalink
• 

  Oscar Francisco Aguilar Jimenez

  • March 23, 2023 13:35

  Thank u, it works perfectly!

  Oscar Aguilar.

  0

  Comment actions Permalink

Please sign in to leave a comment.