Tag Archives: WEEK
Date & Time Functions
Date & Time Functions
| ADays | Returns an array with the days names |
| AddMonth | Adds or subtracts months to/from a date |
| AMonths | Returns an array with the months names |
| BOM | Beginning date Of Month of given date |
| BOQ | Date of beginning Of quarter containing given date |
| BOY | Date to find first day of year, default is DATE() |
| CDoW | Converts a date to the day of week |
| CMonth | Return the name of the month |
| CToD | Converts a character string to a date expression |
| CToDoW | Convert name of day of the week to its ordinal number |
| CToMonth | Convert name of month to its ordinal number |
| Date | Return the Current OS Date |
| Day | Return the numeric day of the month |
| Days | Convert elapsed seconds into days |
| DaysInMonth | Returns the number of days in month |
| DaysToMonth | Total number of days from first of Jan to beginning of nMonth |
| DMY | Returns the date as a string in DD Month YY format |
| DoW | Value for the day of week |
| DOY | Determines the day of the year for a specific date |
| DToC | Date to character conversion |
| DToS | Date to string conversion |
| ElapTime | Calculates elapted time |
| EOM | End Of Month |
| EOQ | Date of end of quarter |
| EOY | Last date Of Year |
| IsLeap | Tests if a specific year is a leap year |
| IsLeapYear | Checks if the given date is a leap year |
| LastDayOM | Determines the number of days in a month |
| MDY | Returns the date as a string in Month DD, YY or Month DD, YYYY |
| Month | Converts a date expression to a month value |
| NToCDoW | Find day name by num of day |
| NToCMonth | Find a month name by the number of month |
| Quarter | Returns a number equal to the quarter in which a date falls |
| Seconds | Returns the number of elapsed seconds past midnight |
| Secs | Return the number of seconds from the system date |
| SecToTime | Converts seconds into a time string |
| Time | Returns the system time as a string |
| TimeValid | Determines whether a specified time is valid |
| TimeToSec | Calculates the seconds since midnight |
| WaitPeriod | Pauses a specified time in increments of 1/100 seconds |
| Week | Returns the calendar week a number |
| WOY | Gets the week number of the year |
| Year | Converts the year portion of a date into a numeric value |
SP_BEGEND
BEGEND()
Short:
------
BEGEND() Determines beginning or end of week,month or quarter
Returns:
--------
<dReturnDate> => Date of beginning/end of week,month,qtr
Syntax:
-------
BEGEND(dStartDate,nBeginEnd,nWkMnthQtr,[nDayofWeek])
Description:
------------
Returns date which is beginning (1) or end (0)
<nBeginEnd> of week (1) , month (2) ,or quarter (3)
<nWkMnthQtr> in which input date <dStartDate> falls. If week,
[nDayofWeek] is day of the week beginning or end of the week
<nBeginEnd> falls on, with Sunday being 1 and Saturday being 7.
Examples:
---------
dDate := ctod("01/15/90")
bow := BEGEND(dDate,1,1,1) // beg of week
eow := BEGEND(dDate,0,1,7) // end of week
bom := BEGEND(dDate,1,2) // beg of month
eow := BEGEND(dDate,0,2) // end of month
boq := BEGEND(dDate,1,3) // beg of quarter
eoq := BEGEND(dDate,0,3) // end of quarter
Source:
-------
S_BEGEND.PRG
CT_WEEK
WEEK()
Returns the calendar week for a date
Syntax
WEEK([<dDate>]) --> nWeekOfYear
Argument
<dDate> Designates a date for which the week it lies in, is
determined. The default is the system date.
Returns
WEEK() returns a sequential week number that designates in which week of
the year <dDate> lies.
Description
The week of the year in which a day lies is information required by a
number of technical financial calculations or wage accounting. This
function determines this week and acknowledged all calendar rules.
Note
. When no date is specified, then WEEK() uses the system date.
An empty date leads to a 0 result.
Example
Determine the week for a date:
dDate := CTOD("03/14/92")
? "This date is in week: ", WEEK(dDate)
Tools — Date/Time Functions
Introduction Date/Time Functions ADDMONTH() Adds or subtracts months to/from a date BOM() Determines the date of the first day of a month BOQ() Determines the date for the beginning of a quarter BOY() Determines the date for the beginning of a year CTODOW() Converts the day of the week name into a corresponding number CTOMONTH() Converts the name of the month into a corresponding number DMY() Returns a date in "DD Month YY" format DOY() Determines the day of the year for a specific date EOM() Determines the date for the last day of a month EOQ() Determines the date for the end of a quarter EOY() Determines the date for the end of the year ISLEAP() Tests if a specific year is a leap year LASTDAYOM() Determines the number of days in a month MDY() Returns a date in the "Month DD, YY" format NTOCDOW() Changes the number of a weekday into a weekday name NTOCMONTH() Changes the number of a month into a month name QUARTER() Determines the quarter in which a specific date lies SECTOTIME() Converts seconds into a time string SETDATE() Sets the system date SETTIME() Sets the system clock SHOWTIME() Continuously displays the time at desired screen position STOD() Converts an ANSI date string into Clipper format TIMETOSEC() Calculates the seconds since midnight TIMEVALID() Determines whether a specified time is valid WAITPERIOD() Pauses a specified time in increments of 1/100 seconds WEEK() Returns the calendar week for a date WOM() Returns the week within a month.
