Today Filter with Arcade

TamT

I use a form for my features that I collect with the Field Maps App. In this form I have the NUMBER field, which I would like to have automatically filled. I also have a DATE/TIME field.

The number I want to have integrated automatically is the highest existing number from today. No problem to filter the highest number, but the today (not 24 hours) and the two conditions together cause some problems to me. Can somebody help? Thanks!

jcarlson

Can you share what you've already tried? Maybe someone can spot where your current expression is not working.

You could also try using EXTRACT in the Filter's SQL expression. Using a backtick string with template literals lets you pipe values into the expression without any concatenation or creating extra variables, and also lets you include line breaks in your expression, which is nice for keeping longer expressions easy to read.

var today_records = Filter(
    $layer,
    `EXTRACT(DAY FROM datetime_field) = ${Day(Today())}
AND EXTRACT(MONTH FROM datetime_field = ${Month(Today())}
AND EXTRACT(YEAR FROM datetime_field) = ${Year(Today())}`
)

var max_number = Max(
    today_records,
    'number_field'
)

return max_number