[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
+---------------------------------+
|              DATE               |
+---------------------------------+
DATE()

-----------------------------------
Returns current system date.
Return value - Date
-----------------------------------

The operating system controls the system date.  There are no FoxPro
commands or functions that can directly change it.

The format of DATE() is modified using the SET CENTURY, SET DATE and SET
MARK commands.

+---------------------------------+
|             Examples            |
+---------------------------------+
? DATE()

SET CENTURY ON
? MDY(DATE())

+---------------------------------+
|         Program Example         |
+---------------------------------+
In example below, INVOICE database is scanned for all records for which
payment is due (based on today's date), but not more
than 30 days overdue.

USE Invoice
SCAN FOR BETWEEN(inv_date, DATE() - 30, DATE())
        ? 'Send notice of payment due for ' + company
ENDSCAN

-----------------------------------

See Also:  SET CENTURY, SET DATE, SET MARK OF, SYS(1) Julian system
date, SYS(10) String from day number, SYS(11) Julian day number

-----------------------------------

See Also: SET CENTURY SET DATE SET MARK OF SYS(1) Julian system
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson