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)