Solved Function to calculate your start and end dates for the current day (1 Viewer)

[victorlindh]

Depends on the values of those date fields.

Now() is 27/04/2024 12:12:20
If Endate is 27/04/2024 10:12:20 that is not going to work.
Best to use Datvalue() on those fields to be sure.

Be better to use Date() as that would be 27/04/2024 00:00:00 and so would less that EndDate, but then not > StartDate if that has time element.

Date() >= DateValue(StartDate) And Date() <= DateValue(EndDate) AS Active

Thanks so much. God bless you.