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,

[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.