Im trying to have a layout which just displays the number of days since the last incident. For example, if today is 01/31/19 and the last incident was on 01/28/31. It should show 3.
I have partially followed a tutorial but the format would be incorrect to what I want. I have begin creating a DataSet under Library. I named it Last Incident.
I created two columns
A. dtLastIncident with the Datatype-Date and Column Type -Value and the order for that is 1.
B. hSinceLast with the DataType-Number and Column Type-Formula and the order for that is 2. The Formula inputed in that is DATEDIFF(NOW(),dtLastIncident)
THen I created a row and put Jan 28 2019 as the last incident but it shows up -301. What did I do wrong?
It should show 3. SInce the date is Jan 31, 2019