How to filter by date only?

Need help
1

image
image700×571 22.1 KB

Context:
I’m trying to build a backend workflow - which sends warning emails to users based on whether they have completed their daily activities or not.

Logic
As long as there is at least 1 Daily belonging to the user, and that the Daily’s lastCompleted date is not today, then send warning email.

Problem
The “Search For” function does not allow me to format LastCompleted (which is a date/time field) as a date form, to compare with today’s date. I need both dates to be formatted in pure date form so I can compare effectively)

Ask
How can I work around this?

2

1. Search for Dailies

  • Type: Dailies
  • Constraint 1: Player = User
  • Constraint 2: lastCompleted > Current date/time:rounded down to day

Logic: “rounded down to day” zeroes out the time (e.g. 2025-06-30 00:00).
So lastCompleted > …00:00 returns only those Dailies completed after midnight today.

2. Only when

  • Search for Dailies:first item is empty

If your search returns no items (i.e. the first item is empty), it means the user hasn’t completed any Daily today.

I hope it helps.