Print      Open PDF Version of Online Help


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 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.