How to write eScript for Date Comparison in a Search Specification?

(Doc ID 529392.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.5.3 SIA [16157] 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:

vStartDate =currBC.GetFieldValue("Start Date");
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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms