| Showing Stats on data with 2 Input Date Fields [message #665928] |
Tue, 03 October 2017 03:30  |
 |
JanCoetzee
Messages: 8
Registered: September 2017
|
Junior Member |
|
|
Hi
I have a table with 2 date fields and other columns. I have to be able to show stats on some of these columns between 2 dates that can be selected from a dropdown list.
All of this must be done in Apex. The client must be able to select a Start Date and an End date and then the count of for instance the number of Referrals between 01/SEP/17 and 30/SEP/17 must be shown.
The SQL code I used in Oracle to achieve this is:
select 'Total Referrals' as Details, count(REFERRED) as Total from PD_PATIENT_DETAILS where REFERRED = 'Yes'
and EVENT_DATE BETWEEN to_date(:EVENT_DATE) AND to_date(:EVENT_DATE_END);
I am now struggling to get this to work in Apex. Like I said before I am new to Apex and don't quite know where to start with this.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
