Date functions
 
Function
Description
Custom or in VFP subset?
DATE()
The current system date is returned.
VFP subset
TIME()
 
The time function returns the system time as a character representation. It uses the following format: HH:MM:SS.
VFP subset
DAY(DATE_VALUE)
 
Returns the day of the date parameter as a numeric value from 1 to 31.
VFP subset
MONTH(DATE_VALUE)
 
Returns the month of the date parameter as a numeric value from 1 to 12.
VFP subset
YEAR(DATE_VALUE)
 
Returns the year of the date parameter as a numeric value.
VFP subset
 
Examples:
TIME() returns 12:00:00 if it is noon.
TIME() returns 13:30:00 if it is 1:30 PM.
DAY(DATE()) Returns 30 if it is the thirtieth of the month.
MONTH( DT_FIELD ) returns 12 if the date field’s month is December.
YEAR( STOD( '19920830' ) ) returns 1992.