ajayz

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"

Outcomes