I'm new to Peoplesoft and their query tool. I'm used to SQL (in the Ceridian Powerquery environment and TOAD) and I'm wondering if you can create a range report (ex. 1/1/2016 to 12/31/2016)?
There are some legacy reports in this environment and it appears that you can do this, but the dates are hard coded. So I'd have to go in to edit, then criteria, then edit for the particular expression (termination date), then I'd have to change the dates in the Expression 2 field.
There must be an easier way to do this - one where I can find the report, select excel, and then it brings me to a screen with two date fields (for the start/end date).
Another approach is to have a "CURRENT_MONTH" table in the system, which would contain information like FISCAL_YEAR, ACCOUNTING_PERIOD, START_DATE, END_DATE, NUM_OF_DAYS, etc. If queries are built joining the CURRENT_MONTH table, then all queries that use the table can run automatically without the need for Prompts, which require manual intervention and can't be used in Scheduled Queries. So if you have a large number of reports and want to run them in an automated fashion without user intervention, this is a good approach.