KB130346 - How to Manipulate DateTime Fields in a Browse

MORE INFORMATION

Visual FoxPro does not offer a command or function that automatically retrieves just the Date or just the Time portion of a DateTime field. The code provided below creates two functions GETDATE() and GETTIME(). The BROWSE command will use those functions to display just the date and just the time of a Datetime field.

Code Sample

*
* Begin Program
*
* This program assumes a table already exists with a DateTime field named
* tField.
*

BROWSE FIELDS date=getdate(tField), time=gettime(tField)

*
* The BROWSE command passes tField to the functions getdate()
* and gettime(). Each function returns to the BROWSE the values of
* justdate and justtime.
*

FUNCTION getdate
PARAMETERS tField
justdate = SUBSTR(TTOC(tField),1,8)
RETURN justdate
ENDFUNC

FUNCTION gettime
PARAMETERS tField
justtime = SUBSTR(TTOC(tField),10)
RETURN justtime
ENDFUNC

* NOTE: The justdate and justtime fields will be read-only at run time.
*
* End Program
*

How to Manipulate DateTime Fields in a Browse

SUMMARY

MORE INFORMATION

Code Sample