Print      Open PDF Version of Online Help

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

Previous Topic

Next Topic

JulianWeek

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

JulianDay / 7

rounded down to the next integer, where JulianDay is the day that is returned by the JulianDay function.

Syntax

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

JulianWeek(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.