Julian_Date()

<< Click to Display Table of Contents >>

Navigation:  Available Functions >

Julian_Date()

Syntax

Julian_Date( <DateValue> )

 

Purpose

To determine the number of days into a year a date is.

 

Parameters

<DateValue> is usually the name of a date field in DonorQuest.

 

Returns

The number of days into the year <DateValue> is.

 

Usage

This function can be used to convert date value to a numeric julian date. Julian dates do not have years, but serve as a count of the number of days that have passed between the first day and some arbitrary date in a particular year.

 

Example

The following examples illustrate JulianDate():

 

CALL

RESULT

Date()

03/07/2014

Julian_Date( Date() )

65