Get(CurrentDate)

Category: Get

Syntax: Get ( CurrentDate )

Parameters: None

Data type returned: Date

Description:

Returns the current date according to the operating 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:

Function

Results

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.

Категории