+4Evening i am looking for SQL help with my quick report. I’m pulling a date column in which i am truncating to split out the time. I want to create a selection box for the user to put a from and to date allowing a range to be displayed.
Would it be easier to pull a single selection box which the user can use the between dates function?
i’m starting with
AND TRUNC(PROMISED_DELIVERY_DATE) BETWEEN DATE '2023-06-22' AND DATE '2024-06-22'
But i need to make the user select the required dates
Best answer by Abdul
Hi
Please refer below query:
SELECT *
FROM CUSTOMER_INFO T
WHERE T.CREATION_DATE BETWEEN TO_DATE('&from_date', 'dd/mm/yyyy') AND
TO_DATE('&to_date', 'dd/mm/yyyy')
System would ask user input.
Regards
Abdul Rehman
+22
+20Hi
Please refer below query:
SELECT *
FROM CUSTOMER_INFO T
WHERE T.CREATION_DATE BETWEEN TO_DATE('&from_date', 'dd/mm/yyyy') AND
TO_DATE('&to_date', 'dd/mm/yyyy')
System would ask user input.
Regards
Abdul Rehman
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
