V victorlindh New member Local time Today, 07:42 Joined Mar 23, 2022 Messages 20 Apr 27, 2024 #21 Gasman said: 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. Code: Date() >= DateValue(StartDate) And Date() <= DateValue(EndDate) AS Active Click to expand... Thanks so much. God bless you.
Gasman said: 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. Code: Date() >= DateValue(StartDate) And Date() <= DateValue(EndDate) AS Active Click to expand... Thanks so much. God bless you.
