PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Need to compare date field with datetime field in SQR

edited Oct 10, 2013 7:52AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 8 commentsAnswered
HI Friends,

I have placed two dates fields on run control page i.e.From & To dates

From Date: 10/08/2013 (MM/DD/YYYY)

To Date: 10/08/2013 (MM/DD/YYYY)

My requirement is to get the details from Process monitor related record for the period selected on the run control page.

I have written the below code to get the data from Process Monitor records and it is working fine if From and To dates are difference Eg: From date: 10/08/2013     To Date: 10/09/2013

But the code is not working if From and To dates are same  Eg: From Date: 10/08/2013   To Date: 10/09/2013

/* SQR Code */

$where_condition = 'WHERE OPRID = ''' || &OPRID2 || ''' AND BEGINDTTM BETWEEN ''' || &DATE1 || ''' AND ''' || &DATE2 || ''''

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