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 date function for expression in popup

ToddHelt

I am trying to use the Arcade "date" function in an expression for a popup to return the day, month, year but without the time. Well actually would like to lose the day of the week too. The documentation I refer to the time as an "optional" field:

IIf(IsEmpty($feature.InspDt), Date($feature.PrevInspDt), Date($feature.InspDt))

Returns this...

"Thu Mar 21 2019 20:00:00 GMT-0400 (Eastern Daylight Time)"

So our archived time data is all mucked up and for our purposes we only really need month, day, year anyway. Is there something I can add to this Arcade Date function so that it returns the date but without the "20:00:00 GMT-0400 (Eastern Daylight Time)", and ideally without the day of the week "Thu" portion as well??

Thank you!

arcgis online arcade‌

arcade attribute expressions‌

#arcade pop-ups‌

Find more posts tagged with

Accepted answers

kenbuja

Have you tried using the Text function to format the date?

Text($feature.PrevInspDt, 'MMMM D, Y')‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

All comments

BugPie

Thank you! Sometimes the answer is not a long read through Arcade date documentation.

ZacharyBaron1

Thanks Ken, that is exactly what I needed!

ToddHelt

Thanks Ken, I had not thought of that...but just tried that and worked in my IIf function, and it worked as desired so good to go!

// Write a script to return a string of the day, month, year from a date field, to show in the pop-up.
// If the InpsDt is null, then display PrevInspDt, otherwise display InspDt
IIf(IsEmpty($feature.InspDt), Text($feature.PrevInspDt, 'MMM D, Y'), Text($feature.InspDt, 'MMM D, Y'))

I think I am getting a little confused about Arcade for labeling and Arcade for expressions in pop-ups.

Would it be correct to say that certain Arcade functions work for popups but don't work in labeling, and vice versa?

kenbuja

Have you tried using the Text function to format the date?

Text($feature.PrevInspDt, 'MMMM D, Y')‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

ToddHelt

Xander,

Thanks for your response, starting to see the light lol. I should have clarified the input date is actually not a string, but rather a date type, and I want to return a string like your snippet. Is there a slight modification you can recommend or it a whole other approach?

Thanks again!
Todd

XanderBakker

Hi Todd Helt ,

You could use something like this (assuming that the input date is a string and you want to return a string):

<SPAN class="keyword token">var</SPAN> InspDt <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Thu Mar 21 2019 20:00:00 GMT-0400 (Eastern Daylight Time)"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> arr <SPAN class="operator token">=</SPAN> <SPAN class="token function">Split</SPAN><SPAN class="punctuation token">(</SPAN>InspDt<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' '</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">return</SPAN> arr<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" "</SPAN> <SPAN class="operator token">+</SPAN> arr<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN><SPAN class="string token">", "</SPAN> <SPAN class="operator token">+</SPAN> arr<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

It will return "Mar 21, 2019".

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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