Hi all, I have a field “Start” (DateTime) in my database. Now I want to list all recordds, where start = currentDATE(dayONLY) Start is a datetime field. How do compare it to match the current day. Example: Record 1: “start” = “12/22/2023 05:17:36pm” Record 2: “start” = “12/05/2023 01:11:22pm” …

Hi there, @jupixy … you can do what you described by using two constraints. Start >= Current date/time:rounded down to date Start < Current date/time:rounded down to date +(days): 1 Best… Mike

If Date/Time IS Current Day (12/22/2023) Problem

Need help

mikeloc December 22, 2023, 2:29pm 6

I think a thread like this one should help you get there.

Topic		Replies	Views
Can you do previous day? Questions	7	1096	April 24, 2019
Check Today's Date vs date in database Database	13	1641	June 20, 2022
Condition: modified date is today Need help	6	1629	March 25, 2021
Need help with Date issue Database	2	311	November 28, 2022
How do I compare the current date/time with the date/time Database	2	306	January 5, 2024

If Date/Time IS Current Day (12/22/2023) Problem

Related topics