Recent content by victorlindh

Thanks so much. God bless you.

I will appreciate if you added input on time element.

SELECT *, Now() >= StartDate And Now() < EndDate AS Active FROM YourTable

SELECT *, Now() >= StartDate And Now() < EndDate AS Active FROM YourTable Criteria Active = True

I have found the solution. Thanks everyone. God bless you so much.

Thanks. I have encountered a slight problem. I am trying to filter using your expressions WHERE >=DateValue(Now()) AND <=DateAdd("s",-1,DateAdd("d",1,[StartOfDay]))

Thanks. Works perfectly

I want to use in a query. Apparently it is not working. Thanks in advance.

How do I apply this code? StartDate: GetCurrentDayDates()(0) EndDate: GetCurrentDayDates()(1)

How do I call this function to calculate your start and end dates for the current day. Kindly look at the attached database

I am defeated. Kindly please assist me.

Hi. If i may ask what is Maschere?

Thanks for this. Working on it now💪💪💪💪

Kindly please assist me with an example. This is the best approach. Thanks in advance.

Hi everyone. I am making school database. I am defeated on how to show only active data. For example we have 3 terms in a year. I want to hide data for previous years for example in 2025 term 3 to be shown and hide for previous years and terms. I wish when the form(FORM4) is opened, the user...