Record List based on current date
Posted: Thu Aug 01, 2024 2:11 pm
how to list a record based on current date only.
how to list a record based on current date only.
You may filter the recordset by using Recordset_Selecting server event.
I try this coding but nothing happen
// Row_Selecting event
function Row_Selecting(&$filter)
{
// Enter your code here
AddFilter($filter, "TimeIn = CurrentDate()");
}
You put in Row_Selecting instead of Recordset Selecting server event.
In addition, you need to enclose the date value by the single quote characters.
I manage to filter the current date by using this code
// Recordset Selecting event
function Recordset_Selecting(&$filter)
{
// Enter your code here
AddFilter($filter, "TimeIn = '".CurrentDate()."'");
}