Is there a way to display in separate list just appointments for this day or week.
I have patients list in wich i edit date and time of next physical thepary and i need a separate page that diplays just apopintments for this day or week.
display just appointments for this day or week
-
- User
- Posts: 22
display just appointments for this day or week
-
- User
- Posts: 9410
You may create a view based on the date field and generate scripts for that view, if you use MySQL, see the date functions: https://dev.mysql.com/doc/refman/8.0/en ... tions.html
-
- User
- Posts: 22
I have maneged to do it my self with a little help of some previosu posts.
I have created VIEW from list that contains dates and set filter in table setup for that VIEW
"SUBSTR(XXX
, 1, 10) = '".getToday()."'"
and i server events global code set
function getToday() {
$today = date("Y-m-d");
return $today;
}
and its working