Field Maps Tasks: Shift-based (06:00–06:00) filtering using esritask_duedate

ZentraleTechnik — Wed, 04 Mar 2026 08:21:09 GMT

Hi everyone,

I’m working with Tasks in ArcGIS Field Maps and I’m trying to implement a shift-based time filter.

Goal / Requirement

We run operational shifts from 06:00 today to 06:00 the next day. We need the task list to be consistent across midnight, e.g.:

A user logs in at 23:00 and sees the tasks for the current shift (06:00 → 06:00).

The same user logs in again at 02:00 (after midnight) and should still see the same shift tasks, not a new set.

The task layer contains the standard due date field esritask_duedate, which is filled and used as the “deadline”.

What works (but not sufficient)

A basic filter like the following is valid and works logically for “calendar day”, but it breaks after midnight because the day changes:

esritask_duedate BETWEEN (CURRENT_DATE + 0.2083333333) AND (CURRENT_DATE + 1.2083333333)

(0.2083333333 = 5/24, intended to represent “06:00 local” depending on time zone setup.)

Problem: when the calendar day changes at midnight, users logging in between 00:00–06:00 see the next day’s window, and tasks from the ongoing shift are no longer included.

Attempted solution (dynamic switch “before/after 06:00”)

To keep the same shift across midnight, I tried a dynamic “switch” logic:

If current time is before 06:00, filter yesterday 06:00 → today 06:00

Else filter today 06:00 → tomorrow 06:00

(

(CURRENT_TIMESTAMP < (CURRENT_DATE + 0.2083333333) AND

esritask_duedate BETWEEN ((CURRENT_DATE - 1) + 0.2083333333) AND (CURRENT_DATE + 0.2083333333))

(CURRENT_TIMESTAMP >= (CURRENT_DATE + 0.2083333333) AND

esritask_duedate BETWEEN (CURRENT_DATE + 0.2083333333) AND (CURRENT_DATE + 1.2083333333))

)

Issue

This expression appears valid in Field Maps Designer, but when opening the map in theField Maps mobile app, Tasks fail to load and the app shows:

“Tasks couldn’t be loaded. Contact the map author for more information.”

I also tested using EXTRACT(HOUR FROM CURRENT_TIMESTAMP) earlier, but Field Maps mobile did not support it either (same outcome).

Question

Is there a Field Maps mobile limitation regarding dynamic SQL functions (CURRENT_TIMESTAMP, EXTRACT, etc.) in Tasks filters / to-do lists?
Is there a recommended approach to implement a 06:00–06:00 shift window using only esritask_duedate that works reliably in Field Maps mobile?
If this is not supported via SQL in Field Maps mobile, what is the best practice workaround?e.g., precomputing a shift anchor field (like shift_date) on insert/update (server-side or via automation), and filtering on that instead?

Any hints, confirmed limitations, or working examples would be greatly appreciated.

Thanks in advance!

Re: Field Maps Tasks: Shift-based (06:00–06:00) filtering using esritask_duedate

LaurentSavoy1 — Thu, 05 Mar 2026 22:00:39 GMT

I’m facing the exact same issues, but only in Field Maps. I’m currently limited by the available date-filtering (temporal filtering) functions—similar to what QFIELD supports (see link above). I can’t create a date filter that returns only the previous shift, which would allow my operators to filter and review what was completed during the prior shift.

https://docs.qfield.org/how-to/advanced-how-tos/temporal-filtering/

I’ll keep an eye on what people post here as a solution.

Re: Field Maps Tasks: Shift-based (06:00–06:00) filtering using esritask_duedate

MarcMuehleisen89 — Tue, 10 Mar 2026 12:20:54 GMT

When testing this, i found out that Date Arithmetic is not supported on the Client although the expression seems to be valid in FieldMaps Designer.
I tested expressions such as CURRENT_DATE + 1 = CURRENT_DATE + 1 which compared to 1=1 delivers no results.

topic Field Maps Tasks: Shift-based (06:00–06:00) filtering using esritask_duedate in ArcGIS Field Maps Questions

Field Maps Tasks: Shift-based (06:00–06:00) filtering using esritask_duedate

Goal / Requirement

What works (but not sufficient)

Attempted solution (dynamic switch “before/after 06:00”)

Issue

Re: Field Maps Tasks: Shift-based (06:00–06:00) filtering using esritask_duedate

Re: Field Maps Tasks: Shift-based (06:00–06:00) filtering using esritask_duedate