Using Julian Functions

The 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