Last date in table

Discussion created by ajayz on Dec 6, 2012
Latest reply on Dec 6, 2012 by Malcolm

Hi guys,


I have an incident registers which tracks all incidents for our company. I would like to calculate how many days have passed since the last reported incident. Bascially just a NUMBER.


I'm not too sure how to write the a calculation find the last incidnet date and then subtract this from current date to get the number of days passed.


The date is stored in a field called: "IncidentDate"