Date Fields

The use of date fields must conform to the proper format for the database platform you use.  The following table outlines date formats for each database platform.

Note: Rarely (if ever) would a filtered on field equal the current Date AND Time; thus, the following Date functions are designed to return the current Date only.

Database Platform

Format

Microsoft Access:

Date Format:

Current Date Function:

 

#1/1/2001#

[FIELD] = Date()

Microsoft SQL Server

Date Format:

Current Date Function:

 

'1/1/2001'

[FIELD] = CONVERT(VARCHAR(10), GETDATE(), 101)

Oracle

Date Format:

Current Date Function:

 

'1/1/2001'

[FIELD] = TRUNC(SYSDATE)

See Also

Advanced Filters

Defining Relationships

Properly Formed Queries

String Values

Boolean Fields

Querying for Null Values

Additional Information

Wildcards in Filters