Date / time picker to search in database

I would like to do a count of each unique id registered in a specific date or a range of date. I am using a text element to do the total count of unique ID, but I am having difficulties to use date/time picker to “filter” the count by date

I think this might help.

To do for a specific date, you first need to get the start and end date time for that date, like this:

Screenshot 2023-11-13 at 2.51.55 PM

The middle date is the “from” date you’d want to use in your selection criteria. The last date is the “to” date you want to use.

You can get these like so:

Screenshot 2023-11-13 at 2.54.04 PM

Screenshot 2023-11-13 at 2.54.12 PM

And you can mess around with the “rounded down” and “add” to get virtually any date range you want.

Hope this helps.

1 Like

You also only need to count users, no need for UIDs.