Calculations with date of creation

Follow

Mario Galea

• June 20, 2015 22:50

Hello,

Is it possible to create a calculation where a result is dependent on the date of creation of the item vis-a-vis the current date?

I have monthly reporting form submissions.
There is a category where they choose the month and another one where they choose year.

If these arrive within the first 6days of the following month or before, the value should be 1.
If the item is created after the 6th day but within the 15th, the value should be 0.5.
After the 15th of the month following the month of the category, the value should be 0.

Is this sort of calculation possible?

thanks and regards

0

• 

  Mario Galea

  • June 26, 2015 02:46

  Date1 = new Date(@Year + @Month + 4)
  Date2 = new Date(@Year + @Month + 15)

  Date1.setMonth(Date1.getMonth() + 1)
  Date2.setMonth(Date2.getMonth() + 1)

  Submit = @Created On

  if (Submit <= Date1){
  Answer = 1
  } else if (Submit <= Date2){
  Answer = 0.5
  } else {
  Answer = 0
  }

  0

  Comment actions Permalink

Please sign in to leave a comment.