Calculate dates Survey123 Connect

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,

Sem título.png

AGOL_WMS_raster.png

SimonCrutchley_0-1740072719101.png

DavidSolari

Calculations between two dates either work using "epoch time" in microseconds or "decimal time" which are whole days with hours, minutes etc. stored in the decimal. This part of the docs explains how to convert between the two and provides examples for doing calculations in both styles.