topic Re: Calculate Number of Days Between Two Dates in ArcGIS Survey123 Questions

Calculate Number of Days Between Two Dates

icf_Eric_Link — Tue, 16 May 2023 18:30:50 GMT

Hello, I've got a form that is tracking usage of equipment. I would like to have the user input a start date and end date and have the form calculate the number of days between the two dates. Does anyone have an idea of an approach for doing this? Thanks in advance.

Re: Calculate Number of Days Between Two Dates

MobiusSnake — Tue, 16 May 2023 18:58:55 GMT

Here's an excerpt from the S123 Formulas doc:

Calculations can be used with the responses in date fields. This calculation estimates the number of years between a date entered and today, ideal for calculating somebody's age:
int((today() - ${birth_date}) div (1000 * 24 * 60 * 60 * 365.25))

Replacing today and birth_date with your two questions and removing 365.25 from the numbers would probably do it, but I haven't tested it.

Re: Calculate Number of Days Between Two Dates

icf_Eric_Link — Tue, 16 May 2023 19:02:03 GMT

Thanks! So I found the doc after I posted and tested it out and it didn't quite work. I did however get the minutes spent for lunch formula to work. Much appreciated for your response.

int((decimal-date-time(${lunchends}) - decimal-date-time(${lunchstarts})) * 24*60)

Re: Calculate Number of Days Between Two Dates

SIG-EscutismoCNE — Mon, 31 Mar 2025 20:31:23 GMT

Hello,

Can anyone help me?

I have a field called "data_de_in_cio_da_actividade" (default: format-date(${wsdatetime},'%H:%M') and another one called "inserir_data_de_submiss_o" (default: now())

I need to receive a message when the field "inserir_data_de_submiss_o" is less than 14 days from the field "data_de_in_cio_da_actividade"

Already tried this expression but without success

date(${data_de_in_cio_da_activity}) - date(${inser_data_de_submiss_o}) < 14

Thanks for your attention,