Hello!
I have a survey that I have built and have some basic calculations to store metrics on the time that a feature has stayed under a previous status for. I have a calculation that evaluates the time Now() and subtracts the time of the last status change to provide the time in that status in minutes. This formula works perfectly on the Survey123 Field App and Connect but doesn't seem to function on the web version. The exact formulas I have tried are:
int((now() - ${previousstatusstarttime}) div (1000 * 60))
int((${statusdatetime} - ${previousstatusstarttime}) div (1000 * 60))
Is the Int function not supported on web? Is there a different way I could do this?
Also, as a bonus question I had a calculation that would break the minutes down into Days, Hours, Minutes for ease of viewing but that also doesn't work. That formula was:
concat(int((now() - ${previousstatusstarttime}) div (1000*60*60*24))," Days ", if(int(((now() - ${previousstatusstarttime}) div (1000*60*60)) mod 24) < 10,"0",""), int(((now() - ${previousstatusstarttime}) div (1000*60*60)) mod 24)," Hours ", if(int(((now() - ${previousstatusstarttime}) div (1000*60)) mod 60) < 10,"0",""), int(((now() - ${previousstatusstarttime}) div (1000*60)) mod 60)," Minutes")
Thank you for any help you can provide!!
