Print      Open PDF Version of Online Help

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

Previous Topic

Next Topic

JulianQtr

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

JulianYear * 4 + current_quarter

where JulianYear is the year returned by the JulianYear function, and current_quarter is:

(current_month - 1) / 3 + 1

rounded down to the next integer.

Syntax

JulianQtr(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:

JulianQtr(Today())

Related Topics

See the following topics for related Expression Builder information:
Published 1/9/2017 Copyright © 2005, 2017, Oracle. All rights reserved. Legal Notices.