topic Re: how to calculate the week number of a date in ArcGIS Survey123 Questions

how to calculate the week number of a date

JavierCMartínezPrieto — Fri, 30 Sep 2022 11:37:06 GMT

I would like to know if it is possible to calculate the number of the week from a date using today() in the calculation field.
I have tried the format-date with the %W operator, but it doesn't work.....

thanks to all of you who participate.

Regards Javier

Re: how to calculate the week number of a date

JohannesLindner — Fri, 30 Sep 2022 12:34:20 GMT

Date Functions | ArcGIS Arcade | ArcGIS Developers

Week(Today())

Re: how to calculate the week number of a date

IsmaelChivite — Sat, 01 Oct 2022 00:27:57 GMT

Hi @JavierCMartínezPrieto

If using the mobile app, go with format-date as shown below:

Unfortunately format-date %W is not supported in the web app. If you want this to work in the web app you will need to use a custom JS function. For example:

function ISO8601_week_no(unix_timestamp) { var dt = new Date(unix_timestamp); var tdt = new Date(dt.valueOf()); var dayn = (dt.getDay() + 6) % 7; tdt.setDate(tdt.getDate() - dayn + 3); var firstThursday = tdt.valueOf(); tdt.setMonth(0, 1); if (tdt.getDay() !== 4) { tdt.setMonth(0, 1 + ((4 - tdt.getDay()) + 7) % 7); } return 1 + Math.ceil((firstThursday - tdt) / 604800000); }

If you are not familiar with custom JS functions. Check this blog.

Attaching samples

Re: how to calculate the week number of a date

JavierCMartínezPrieto — Mon, 03 Oct 2022 06:31:43 GMT

thank you for answering both of them.

Best regards Javier

Re: how to calculate the week number of a date

mikaël — Fri, 23 Jun 2023 14:23:49 GMT

this is misleading since arcade functions do not work in survey123