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; } } }

Arcade Second() Function Cutting Off Leading Zero

LeviCecil

So I'm calculating total drive times in Network Analyst. I have an end time field that I'm trying to strip the minutes and seconds from for a new field. It's a date field formatted like so: 9/16/2019 8:01:06 AM. I enter Minute(EndTime) + ":" + Second(EndTime) in the field calculator. The issue is, I'm getting resulting times like 1:6 which should read 1:06, or one minute, six seconds. What gives??

Encontre mais publicações marcadas com

Accepted answers

LeviCecil

I used this Text(EndTime, 'mm:ss')

All comments

LeviCecil

I used this Text(EndTime, 'mm:ss')

LeviCecil

Thanks Xander. This works, but only for times over one minute (see screenshot).

XanderBakker

Hi Levi Cecil ,

In addition to the correct answer provided by Lance Cole , it is important to understand that the Second function returns a number, not a text:

Second( dateValue ) -> returns: Number

See: Date Functions | ArcGIS for Developers

You want to get the result in a certain format and that is obtained by using the Text function as Lance described. In this case you don't have to use the Second and Minute functions, but by providing the desired format "m:ss" or "mm:ss" (what ever suits your need most) you can use a single function. To see more formatting options, please see: Data Functions | ArcGIS for Developers

LanceCole

Levi Cecil‌,

Try the following: Text(EndTime, 'm:ss')

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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