Progress
Report Builder
User’s Guide
- Date Subtraction
Subtracts a number of days from a date to produce a date result, or subtracts one date from another to produce an integer result that represents the number of days between the two dates.
SYNTAX
date
An expression that evaluates to a DATE value.
days
An expression that evaluates to a DATE value.
EXAMPLEThis expression finds orders with a promise date of more than a week ago. The expression subtracts seven days from the current system date, then compares the date to the value in the Promise-Date field:
NOTE
The date subtraction operator rounds days to the nearest integer value.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |