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) |