Need to compare date field with datetime field in SQR
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 || ''''