PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How do I set a PS Query Prompt Default for Date in Relation to Current Date?

edited Oct 14, 2020 9:09PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered ✓

In PS Query Manager, I know I can set a query date prompt to default to the current date by entering '% Date' in the Default Value box on the prompt. However, I actually have a need to set the default to the current date + 11 days. The default will be used for scheduling the query and I also want it to be available to run ad-hoc and select a date. When I enter '%Date+11', I receive the error message: Invalid Prompt Default Value (139,597).

We are on PeopleTools 8.57.05

Can someone let me know if this is possible, and if so, the correct default value to use? Thank you!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center