Progress
Report Builder
User’s Guide


Day, Date, and Time Functions

Table B–3 lists the Report Builder functions that manipulate and provide information about the day, date, and time.

Table B–3: Day, Date, and Time Functions 

Syntax
Input Data
Output Data
In
4GL
DATE ( string )1
C
D
DAY ( date )
D
N
MONTH ( date )
D
N
QUARTER ( date )
D
N
QUARTER-START ( date )
D
D
SPELL-MONTH ( date )
D
C
SPELL-WEEKDAY ( date )
D
C
TIME ( )
N/A
N
TODAY ( )
N/A
D
WEEKDAY ( date )
D
N
YEAR ( date )
D
N
  1. Report Builder functionality differs slightly from 4GL functionality.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095