How to write eScript for Date Comparison in a Search Specification?
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 7.5.3 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
This document was previously published as Siebel SR 38-1079185471.
Checked for Relevance on 13-04-2015
Regarding the following code:
vEndDate =currBC.GetFieldValue("End Date");
vSubStrStartDate = vStartDate.substring(0,10);
vSubStrEndDate = vEndDate.substring(0,10);
var vSearchString = vPartnerId + " AND 'Receipt Date' >='"+ vSubStrStartDate + "' AND 'Receipt Date' <='" + vSubStrEndDate + "'"
vBCOther.SetSearchSpec("Primary Organization Id",vSearchString);
The Script is working as intended. Please confirm following regarding the Date Comparison:
1. Can I use the above way to compare dates?
2. Is there any way of using "between" operator?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms