Get(CurrentDate)

Get(CurrentDate)

Category: Get

Syntax: Get ( CurrentDate )

Parameters: none

Description: Returns the current date according to the system calendar.

The format of the result varies based on the date format that was in use when the database file was created. In the United States, dates are generally in the format MM/DD/YYYY. You can change a computer's date format in the Regional Settings Control Panel (Windows 2000), the Date and Time Control Panel (Windows XP), or the Date & Time System Preference (Mac OS X).

If the result is displayed in a field, it is formatted according to the date format of the field in the current layout.

Examples:

 DayName ( Get (CurrentDate) - 30 ) 

Returns the day name for the date 30 days prior to today.

 Get (CurrentDate) - InvoiceDate 

Returns the number of days outstanding for a given invoice.