display just appointments for this day or week

ceeronne · Post by **ceeronne** » Fri May 03, 2019 11:43 pm

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.

arbei · Post by **arbei** » Sat May 04, 2019 10:04 am

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

ceeronne · Post by **ceeronne** » Sat May 04, 2019 9:42 pm

I have made a VIEW from my table PATIENTS to show list of patients with date row ascending but i want it to show just list of those who have apointment today or for this week or month

ceeronne · Post by **ceeronne** » Wed May 08, 2019 8:40 pm

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