I am trying to calculate "Days since last rainfall" in my form.

Question

I have inspection date set to today() and a field for date of last rainfall but it is giving nme decimals as answers as it is accounting for hours..how can I change this?  I tried using the round function in the constraints field but it doesn't work.  I also have the field set to integer but it doesn't seem to matter..

AmyStorey · Answer

ChristopherMatechik · Answer

Sorry. I had a minute to test my suggestion and I realized there are some mistakes. I was able to make it work though.

round((decimal-date-time(${Inspection_Date}) - decimal-date-time(${Last_Rain})),0)

Put this in the calculation column of an integer field and it should work. Be sure to replace the field names with whatever you named your fields in your form.

ChristopherMatechik · Answer

I think this will work better if you convert your dates to decimal time. I recently wrote a function to determine when a nest would be 55 days old based on the date it was documented. It looked like this.

date (decimal-date-time(${Date_Found}) + 55)

I would think you could try something similar. Maybe:

date(decimal-date(${today} - decimal-date(${Date_of_Last_Rainfall}))

Let me know if it works.