nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Date off by a month using Arcade

Gisbert61

A collegue used collector to record some records but a datefield wasn't filled. I decided to use arcade to fill the field:

But instead of May 11th I see June 10th. This is so confusing.

I understand that date is stored in utc but displayed in my local timezone (I'm near Amsterdam) so I was expecting some hours difference but this seems more than a month.

What am I doing wrong?

regards,

Bert

Trouver plus de publications taguées avec

Accepted answers

kenbuja

When using the Date function, months are defined by 0-11 instead of 1-12.

month Number The month (0-11) where 0 is January and 11 is December.

All comments

jfisher

This seems pretty insane to me: months are randomly zero indexed? Who would have checked off on this? This is clearly a bug.

bogrevy

Although it is stated in the documentation for both the Date function and the Month function, it makes no sense at all that this is 0-based.

The problem with changing that is that any existing arcade expressions that use these functions will fail. I would still recommend Esri to change these features instead of continuing to bear the pain all the following years.

DanThompson

yeah it makes no sense..

JonathanJew1

Can anyone explain why the month() would be indexed at 0, while day() and year() actually returns what one would expect? Python treats months consistently, and I just can't wrap my head around why arcade would have been designed this way.

kenbuja

When using the Date function, months are defined by 0-11 instead of 1-12.

month Number The month (0-11) where 0 is January and 11 is December.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Se connecter
S'inscrire

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.