Question

date

i have date column in database

it holds the values like

01/02/2024 06:29 GMT+00:00

17/03/2023 17:59 GMT+00:00

but i have to fetch only date which is equal to today date

how can i achieve that

Brainy

The most simple option is to query for datetimes that are inside a 24 hour range using the "between" operator.

Participating Frequently

a!forEach(
  items: todate(column name using rule query),
  expression: if(fv!item=today(),fv!item,{})
)

Anmol

Brainy

Loading data to "filter" it in Appian is an anti-pattern and to be avoided!

Sign up