Bookshelf Home | Contents | Index | PDF |
Siebel Developer's Reference > Operators and Expressions > Expressions > Using Julian FunctionsThe Julian functions must include the Today function or a field name as an argument. For example: JulianMonth([Created]) (of a field) or JulianMonth(Today()) (of the current date). The following example includes the JulianMonth function in a predefined query to get the opportunities that Siebel CRM closed during the previous month: 'Opportunity'.Search = "JulianMonth([Close Date]) = JulianMonth(Today()) - 1" The following example returns all service requests that include a commit time that occurs two days in the future: 'Service Request'.Search = "JulianDay([Commit Time]) = JulianDay(Today()) + 2" The following example sets a variable to the integer value of the current month: currentMonth = JulianMonth(Today()) - JulianYear(Today()) * 12 |
Siebel Developer's Reference | Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |