AnsweredAssumed Answered

Adding DAYS to a Date

Question asked by ajayz on Nov 25, 2012
Latest reply on Nov 25, 2012 by robwoof



I have a date field called "ISSUED" (the date they completed training), I want to add either 1 month or 30 days (both options will work) to this date to create a calculated field with the new date called "SOTExpiry".


The Training certificate is only valid for 30days from the date of issued - by this time they should have recieved their qualification card.


I understand that date fields are represented in seconds and thefore I need to add 30 days X 86400 (60 seconds/minutes * 60 minutes/hours * 24 hours/day)


I've created a calculated field with the forumal = ISSUED +30* 86400


I've changed the "calculation result is" Date


however in my report this field only shows " ?"


Can someone point me in the right direction or is there another option I should be looking at?