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 - { days | date } 

date

An expression that evaluates to a DATE value.

days

An expression that evaluates to a DATE value.

EXAMPLE

This 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:

TODAY() - 7 > Promise-Date 

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