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