DATE_JULIAN macro

The DATE_JULIAN macro is available only in Unica Campaign.

Syntax

DATE_JULIAN(year, month, day)

Parameters

year

Valid 2-digit or 4-digit year number.

month

Valid month number between 1-12.

day

Valid day number between 1-31.

Description

DATE_JULIAN returns the Julian date of the specified input. The Julian date is the number of days elapsed since January 1, 0000.

Examples

DATE_JULIAN (2000,08,31) returns the number 730729.

Related functions

Function Description
DATE Converts a date string to a Julian date.
DATE_FORMAT Converts dates from one format to another.
DATE_STRING Returns the date string of the Julian date.