It's best to share what you have because we do not know your format of the data, column names etc so anything is a generic guess.
You said
I would like to refresh this list daily to update the 'Days Open' field based on the 'Notification Date ' and current date
That doesn't tell me do you want them to be equal, less than, greater than, without 3 days of each other etc so its hard to write your expression
What I can tell you is you need to use formatDateTime and then use the same formatter like "dd/MM/yyyy" on both values so that when it compares its the same
formatDateTime(mycolumnofdata, "dd/MM/yyyy")
and now to compare them
equals(formatDateTime(,mycolumnofdata), 'dd/MM/yyyy'),
formatDateTime(utcNow(), 'dd/MM/yyyy))
now I am assuming your values are compatible with utc, if not you will need to convert it to UTC first for it to work
The back end is utc by default, so it depends wher your data is stored
equals(
convertToUtc(formatDateTime(,mycolumnofdata), 'dd/MM/yyyy'),
yourtimezonehere),
formatDateTime(utcNow(), 'dd/MM/yyyy)
)
If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.
Thank you!
Sincerely, Michael Gernaey
