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

conditional label

RobertCottreau

I'm trying to create an expression in ArcGIS Online to label a polygon as "Closed" if today's date falls between the date in the ClosedDate field and the ReopenDate field but not to label anything if it is not between those dates or if either of those fields is blank/empty.

I can't have a field with "Closed" as there are popups and I don't want this text to confuse the user.

Thanks to all.

Find more posts tagged with

Accepted answers

kenbuja

You can use this syntax

if ($feature.ClosedDate <= Today() && Today() <= $feature.ReopenDate) return "Closed";

All comments

kenbuja

The only case where it wouldn't return null with blank fields is if the ClosedDate was blank and the ReopenDate was after today. That would return "Closed". That's why I was asking what you would want to show if one field was blank but the other had a Date.

You can test the variants in the Arcade Playground with this code.

var ClosedDate = null;
//var ClosedDate = Date(2024,1,1);
var ReopenDate = Date(2024,1,14);
//var ReopenDate = null;
if (ClosedDate <= Today() && Today() <= ReopenDate) return "Closed";

RobertCottreau

they could both be blank because some fields aren't closed at any time in which case there is no label

kenbuja

A better question is what would you want to see if one if blank and the other isn't.

kenbuja

Would both of them be blank or would you have cases where only one is blank?

RobertCottreau

This work perfectly. Thanks, Ken.

And it automatically excludes any instances where the ClosedDate and/or ReopenDate fields are blank?

kenbuja

You can use this syntax

if ($feature.ClosedDate <= Today() && Today() <= $feature.ReopenDate) return "Closed";

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.