Siebel Developer's Reference > Operators, Expressions, and Conditions > Functions in Calculation Expressions >

About Using Julian Functions

The 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