Date parameter is throwing an error — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Date parameter is throwing an error

edited Mar 16, 2025 5:34PM in Reporting and Analytics for HCM 7 comments

Summary: A date value is stored in the screen_entry_value field.

I created two date parameters (p_week_start, p_week_end).

I am trying to use the screen_entry_value in my where condition.

and to_date(peevf.screen_entry_value, 'YYYY-MM-DD HH24:MI:SS') between :p_week_start and :p_week_end

But then I get the below error.

What am I doing wrong?

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):24D



Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!