Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Showing Stats on data with 2 Input Date Fields (Apex 5.1.0.00.45, Windows)
Showing Stats on data with 2 Input Date Fields [message #665928] Tue, 03 October 2017 03:30 Go to previous message
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.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Field replacement
Next Topic: change keyboard language when change textfiled
Goto Forum:
  


Current Time: Tue Sep 22 20:25:08 CDT 2020