nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculate Number of Days Between Two Dates

icf_Eric_Link

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.

Najděte více příspěvků označených jako

Accepted answers

icf_Eric_Link

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)

All comments

SIG-EscutismoCNE

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,

icf_Eric_Link

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)

MobiusSnake

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.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.