Function: Date

Description

Returns the date portion of a given date/time or today's date.

Syntax

Date([date])

Arguments

Date/time (optional)

Return value

This function returns a date in the form YYYYMMDD.

Calculated field example

If you were reading this help message on September 17, 2005, the following expression would return the value 20050917 (i.e., today's date in YYYYMMDD format): Date()

Filter/Find example

Records representing invoices more than thirty days past due can be selected or found using the expression: Date()-Due_date>30