Progress
Report Builder
User’s Guide


WEEKDAY

Evaluates a date expression and returns the day of the week as an integer from 1 (Sunday) to 7 (Saturday) for that date.

SYNTAX

WEEKDAY ( date ) 

date

A date expression (a constant, field name, or expression that results in a date value) for which you want the day of the week.

EXAMPLE

To convert the day of the week for a field Invoice-Date to its numeric form, create a calculated field containing this expression:

WEEKDAY(Invoice-Date) 

Sample data:

Invoice-date      WEEKDAY(Invoice-Date)
01/11/92               2
01/13/93               4
01/15/93               6 


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