<< Click to Display Table of Contents >> Navigation:  Available Functions > Date()

Syntax

Date()

Purpose        

To return the system date (today's date) as a date value.

 

Parameters

None.

Returns                

A Date value.

Usage                

This function is intended to be used when comparing the dates of donations or pledges against the current date.

Example                

If you are using the "Sum_In()" function to add up donation amounts for each donor, and you wish to only add up donations which were made during the past year, then you could use the "Date()" function to get the value of today's date, subtract 365 days, and compare the resulting date against each donation date. The actual condition might look like this:

 

.Donation_Date. >= (Date() - 365)