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
Discussion posts and replies are publicly visible
The most simple option is to query for datetimes that are inside a 24 hour range using the "between" operator.
a!forEach( items: todate(column name using rule query), expression: if(fv!item=today(),fv!item,{}) )
Loading data to "filter" it in Appian is an anti-pattern and to be avoided!