Print      Open PDF Version of Online Help

Administering Oracle CRM On Demand > Expression Builder > Expression Builder Functions > JulianMonth

Previous Topic

Next Topic

JulianMonth

The JulianMonth function in Expression Builder returns an integer that is equal to:

JulianYear * 12 + current_month

where JulianYear is the year that is returned by the JulianYear function, current_month is an integer from 1-12, and January is 1.

Syntax

JulianMonth(date)

Result Type

Integer

Arguments

The following table describes the arguments for the function.

Argument

Description

date

A field name that returns a date data type.

To return the value for today's date, use the following syntax:

JulianMonth(Today())

Related Topics

See the following topics for related Expression Builder information:
Published 6/21/2021 Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices.