Home > lang > date 
 en fr de es it nl pl pt pt_BR mk sq ca hu cs tr ar fa id vi ko ja zh zh_TW eo
Previous  Next  Edit  Rename  Undo  Search  Administration  
Documentation  
Warning! This page is not translated.  See english version 
Date
Result = Date ( Expression ) As Date

Return the date part of a date & time expression.

Example

PRINT Now; " -> "; Date(Now)

05/16/2002 15:10:59 -> 05/16/2002

Date
Date = Date ( Year , Month , Day [ , Hours , Minutes , Seconds ] ) AS Date

Make a date from its components.

PRINT Date(1972, 09, 06, 1, 5, 17)

09/06/1972 01:05:17

PRINT Date(1972, 09, 06, 1, 5, 17)
PRINT CFloat(Date(1972, 09, 06, 1, 5, 17))

06.09.1972 01:05:17
2473671,04533565

See also

Date & Time Functions