https://community.esri.com/t5/arcgis-survey123-questions/calculate-dates-survey123-connect/m-p/1601567#M61966 <P>Hello,</P><P>&nbsp;</P><P>Can anyone help me?</P><P>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())</P><P>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"</P><P>Already tried this expression but without success</P><P>date(${data_de_in_cio_da_activity}) - date(${inser_data_de_submiss_o}) &lt; 14</P><P>&nbsp;</P><P>Thanks for your attention,</P> Tue, 01 Apr 2025 20:42:32 GMT SIG-EscutismoCNE 2025-04-01T20:42:32Z https://community.esri.com/t5/arcgis-survey123-questions/calculate-dates-survey123-connect/m-p/1601567#M61966 <P>Hello,</P><P>&nbsp;</P><P>Can anyone help me?</P><P>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())</P><P>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"</P><P>Already tried this expression but without success</P><P>date(${data_de_in_cio_da_activity}) - date(${inser_data_de_submiss_o}) &lt; 14</P><P>&nbsp;</P><P>Thanks for your attention,</P> Tue, 01 Apr 2025 20:42:32 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculate-dates-survey123-connect/m-p/1601567#M61966 SIG-EscutismoCNE 2025-04-01T20:42:32Z https://community.esri.com/t5/arcgis-survey123-questions/calculate-dates-survey123-connect/m-p/1601585#M61967 <P>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. <A href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/decimaldatetime.htm#GUID-6654B933-37F6-43FE-8A6D-E948896CD01C" target="_self">This part of the docs</A> explains how to convert between the two and provides examples for doing calculations in both styles.</P> Tue, 01 Apr 2025 21:22:47 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculate-dates-survey123-connect/m-p/1601585#M61967 DavidSolari 2025-04-01T21:22:47Z