FT_WEEK()
Return calendar or fiscal week data
Syntax
FT_WEEK( [ <dGivenDate> ], [ <nWeekNum> ] ) -> aDateinfo
Arguments
<dGivenDate> is any valid date in any date format. Defaults
to current system date if not supplied.
<nWeekNum> is a number from 1 to 53 signifying a week.
Defaults to current week if not supplied.
Returns
A three element array containing the following data:
aDateInfo[1] - The year and week as a character string "YYYYWW"
aDateInfo[2] - The beginning date of the week
aDateInfo[3] - The ending date of the week
Description
FT_WEEK() returns an array containing data about the week
containing the given date.
Normally the return data will be based on a year beginning
on January 1st with weeks beginning on Sunday.
The beginning of year date and/or beginning of week day can be
changed by using FT_DATECNFG(), which will affect all subsequent
calls to FT_WEEK() until another call to FT_DATECNFG().
The beginning of year date and beginning of week day may be reset
to January 1 and Sunday by calling FT_DATECNFG() with no
parameters.
Examples
// get info about week containing 9/15/90
aDateInfo := FT_WEEK( CTOD("09/15/90") )
? aDateInfo[1] // 199037 (37th week)
? aDateInfo[2] // 09/09/90 beginning of week 37
? aDateInfo[3] // 09/15/90 end of week 37
// get info about week 25 in year containing 9/15/90
aDateInfo := FT_WEEK( CTOD("09/15/90"), 25 )
? aDateInfo[1] // 199025
? aDateInfo[2] // 06/17/90 beginning of week 25
? aDateInfo[3] // 06/23/90 end of week 25
// get info about week 25 in current year( 1991 )
aDateInfo := FT_WEEK( , 25 )
? aDateInfo[1] // 199025
? aDateInfo[2] // 06/16/91 beginning of week 25
? aDateInfo[3] // 06/22/91 end of week 25
Source: WEEK.PRG
Author: Jo W. French dba Practical Computing
See Also: FT_DATECNFG() FT_MONTH() FT_QTR() FT_YEAR() FT_DAYTOBOW()
Pingback: FT Date-Time | Viva Clipper !