Another Date Query
Is there a more efficient way to do the following?
I have a report that has the user parameters of :FISCALYR (fiscal year) and :REPMONTH (reporting month).
I want to allow the user to select a fiscal year and the option to leave the month blank or select a month.
If the user leaves the month blank the selection of order dates would be a range of dates between the beginning of the fiscal year and the last day of the month prior to the month selected from sysdate.
If the month is selected then the range would be between the first day of the selected month and the last day of the selected month.
I have a report that has the user parameters of :FISCALYR (fiscal year) and :REPMONTH (reporting month).
I want to allow the user to select a fiscal year and the option to leave the month blank or select a month.
If the user leaves the month blank the selection of order dates would be a range of dates between the beginning of the fiscal year and the last day of the month prior to the month selected from sysdate.
If the month is selected then the range would be between the first day of the selected month and the last day of the selected month.
0