| AddCentury |
Description: Replaces YY by YYYY in various date formats
Syntax: 'obj' Świ 'AddCentury'dateformat years
dateformat: indicates in which format dates are supplied in 2nd argument
'Y' means dates suplied as YY or YYYY … YYYY
'YM' means dates suplied as YYMM or YYYYMM … YYYYMM
'YMD' means dates suplied as YYMMDD or YYYYMMDD … YYYYMMDD
'Y/M' means dates suplied as 'YY/MM' or 'YYYY/MM' … YYYYMM
'Y/M/D' means dates suplied as 'YY/MM/DD' or 'YYYY/MM/DD' … YYYYMMDD
'MY' means dates suplied as 'MMYY' or MMYYYY' … YYYYMM
'DMY' means dates suplied as DDMMYY or DDMMYYYY … YYYYMMDD
'M/Y' means dates suplied as 'MM/YY' or 'MM/YYYY' … YYYYMM
'D/M/Y' means dates suplied as 'DD/MM/YY' or 'DD/MM/YYYY' … YYYYMMDD
'MDY' means dates suplied as MMDDYY or MMDDYYYY … YYYYMMDD
'M/D/Y' means dates suplied as 'MM/DD/YY' or 'MM/DD/YYYY' … YYYYMMDD
dates: vany array of dates in YYYYMMDD (or YYYYMM) format
Window rule: any YY date above ‘‘yearmax is considered in 20th century
and any YY date below ‘‘yearmax is considered in 21st century |
| Calendar |
Description: Return N×6×7 numeric matrix calendar for months in YYYY and/or YYYYMM dates
Example: 'dd' Świ 'Calendar'199912 200002 |
| DateBase |
Description: Converts dates from YYYYMMDD format to number of days since 19000101
Note: Applying DateBase on 19000101 returns 0
Example: 'dd' Świ 'DateBase' 20000229 20000301
'dd' Świ 'DateBase' (2 2˝20000229 20000301) |
| DateCheck |
Description: Returns 1 for valid YYYYMMDD dates, 0 otherwise
Example: 'dd' Świ 'DateCheck'19991231 20000229 |
| DateFormat |
Description: Returns a nested vector of formatted YYYYMMDD dates according to specified format for specified language
Syntax: 'obj' Świ 'Date'dates country_id'format'
country_id: country phone prefix
dates: scalar or vector of dates in YYYYMMDD format
format: string containing d dd ddd dddd m mm mmm mmmm yy and/or yyyy
where: d means day number
dd means day number prefixed with 0 if necessary
ddd means abbreviated day name
dddd means day name
m means month number
mm means month number prefixed with 0 if necessary
mmm means abbbreviated month name
mmmm means full month name
yy means 2-digits year
yyyy means 4-digits year
Example: 'dd' Świ 'DateFormat' (19991231 20000101)33'd/m/yy' |
| DateRep |
Description: Converts number of days since 19000101 to YYYYMMDD dates
Note: Applying DateRep on 0 returns 19000101
Example: 'dd' Świ 'DateRep' 36523 36524 „… 19991231 20000101 |
| DateRepExcel |
Description: Converts number of days since 18991231 to YYYYMMDD dates
Note: Applying DateRep on 0 returns 19000101
Returns a matrix of: YYYYMMDD HHMMSS dates and times |
 |
| DateTimeExcelConvert |
Description: Converts date times from YYYYMMDDHHMMSS format to NNNNNN.HHH Excel format
Syntax: 'obj' Świ 'DateTimeExcelConvert'yyyymmddhhmmss
yyyymmddhhmmss: any APL scalar or vector of date times in YYYYMMDDHHMMSS format' |
|
| DateTimeExcelDConvert |
Description: Converts date times from NNNNNN.HHH Excel format to YYYYMMDDHHMMSS format
Syntax: 'obj' Świ 'DateTimeExcelDConvert'NNNNNN.HHH © LES11jun05 D added
NNNNNN.HHH: any APL scalar or vector of date times in NNNNNN.HHH format
Note: this method is very useful in converting DateTime data coming from © LES11jun05 added
Excel or from Relational Database fields © LES11jun05 added
Example:
'dd' Świ 'DateTimeExcelDConvert'38012.365465 |
| DateTimeFormat |
Description: Convert a matrix of YYYYMMDD HHMMSS date times
Syntax: 'obj' Świ 'DateTimeFormat'datetimemat country dateformat
Returns a matrix of formatted date times |
| DateUnformat |
Description: Converts dates formatted as {ddd} d mmm yy or {ddd} d mmm yyyy to yyyymmdd
Syntax: yyyymmdd„'obj' Świ 'DateUnformat'dates
dates: vector of char vectors of dates in {ddd} d mmm yy or {ddd} d mmm yyyy format
yyyymmdd: numeric vector of dates in yyyymmdd format
Note: this method currently only supports French & English formatted dates
Example:
'dd' Świ 'DateUnformat' 'mon 8 feb 03' '' 'fri 10 oct 2003' |
| DayEndWeek |
Description: Return last day of week (sundays) as YYYYMMDD dates for YYYYMMDD dates
Syntax: 'dd' Świ 'DayEndWeek'dates
Example: 'dd' Świ 'DayEndWeek'19991231 20000105 „… 20000102 20000109 |
| DayOfWk |
Description: Return day of week for YYYYMMDD dates
1=Monday 2=Tuesday ... 7=Sunday
Example: 'dd' Świ 'DayOfWk'19991231 20000101 „… 5 6 |
| DayOfYr |
Description: Return day of year for YYYYMMDD dates
Returns number of days since YYYY0101 for YYYYMMDD dates
Example: 'dd' Świ 'DayOfYr'19991231 20000101 „… 365 1 |
| DayStartWeek |
Description: Return 1st day of week (mondays) as YYYYMMDD dates for YYYYMMDD dates
Syntax: 'dd' Świ 'DayStartWeek'dates
Example: 'dd' Świ 'DayStartWeek'19991231 20000105 „… 19991217 20000103 |
| Days |
Description: Returns days of week as a nested vector in specified language
Syntax: 'obj' Świ 'Days'country_id
country_id: phone country id (default: 33=France)
Example: 'dd' Świ 'Days'33 |
| DaysAb |
Description: Returns abreviated days of week as a nested vector in specified language
Syntax: 'obj' Świ 'DaysAb'country_id
country_id: phone country id (default: 33=France)
Example: 'dd' Świ 'Days'33 |
| DaysAdd |
Description: Adds (3śŚwarg) days to (2śŚwarg) YYYYMMDD dates
Example: 'dd' Świ 'DaysAdd' (19991231 20000229)1 „… 20000101 20000301 |
| DaysBetween |
Description: Returns YYYYMMDD dates for all days between 2 YYYYMMDD dates
Syntax: 'ff.date' Świ 'DaysBetween'startdate enddate
Example: 'ff.date' Świ 'DaysBetween'20001205 200010228 |
| DaysDiff |
Description: Returns number of days between YYYYMMDD dates specified in argument
Example: 'dd' Świ 'DaysDiff' (20000101 20000301)19991231 „… 1 61 |
| DaysInMonths |
Description: Return YYYYMMDD dates of all days in months YYYYMM or YYYYMMDD
Example: 'dd' Świ 'DaysInMonths'200002 „… 20000200+Ľ29 |
| DaysInWeeks |
Description: Return YYYYMMDD dates of all days in weeks YYYYWW
Example: 'dd' Świ 'DaysInWeeks'200002 200052 „… |
| DaysInYears |
Description: Return YYYYMMDD dates of all days in years YYYY, YYYYMM and/or YYYYMMDD
Example: 'dd' Świ 'DaysInYears'1999 200002 |
| JulianDate |
Description: Convert a Gregorian-style date (YYYYMMDD) to a ¨Julian Day Number¨" © LES10may01 added
Syntax: 'ff.date' Świ 'JulianDate'date" © LES10may01 added
Any rank & shape array accepted." © LES10may01 added
Constants: 1721058 „ 1-Jan-0001; 2299160 „ 4-Oct-1582" © LES10may01 added |
| LeapYr |
Description: Indicates if years in YYYYMMDD YYYYMM or YYYY dates are leap years
Example: 'dd' Świ 'LeapYr'19991231 2000 200011 „… 0 1 1 |
| Months |
Description: Add N months to YYYYMM months
Example: 'dd' Świ 'MonthsAdd' (199912 200001) (1 12) „… 200001 200101 |
| MonthsAb |
Description: Returns abreviated months as a nested vector in specified language
Syntax: 'obj' Świ 'MonthsAb'country_id
country_id: phone country id (default: 33=France)
Example: 'dd' Świ 'MonthsAb'1 |
| MonthsAdd |
Description: Add N months to YYYYMM months
Example: 'dd' Świ 'MonthsAdd' (199912 200001) (1 12) „… 200001 200101 |
| NbDaysInMonths |
Description: Return number of days in months YYYYMM or YYYYMMDD
Example: 'dd' Świ 'NbDaysInMonths'200002 19991225 „… 29 31 |
| New |
Description: Create a new instance of TDates5
Example:
'obj' Świ '*Create' 'TDates5'
|
|
| Short2LongDate |
Description: Converts an "ddd d mmm yyyy" formatted date to an "dddd d mmmm yyyy" formatted date (see method <DateFormat> comments)
Syntax: longdate„'obj' Świ 'Short2LongDate'shortdate
shortdate: a 'ddd d mmm yyyy' formatted date
longdate: a 'dddd d mmmm yyyy' formatted date
Note: this method is sensible to your current <country> setting
You must provide a date in ddd d mmm yyyy in the locale corresponding to your <country> setting
Example:
'dd' Świ 'country'1
'dd' Świ 'Short2LongDate' 'Tue 23 Jul 2004'
Tuesday 23 July 2004
'dd' Świ 'country'33
'dd' Świ 'Short2LongDate' 'Mar 23 Déc 2004'
Mardi 23 Décembre 2004
'dd' Świ 'Short2LongDate' 'Tue 23 Jul 2004'
??? 23 Juillet 2004 |
| Today |
Description: Returns today's date in YYYYMMDD format |
| Wk2Month |
Description: Returns YYYYMM months corresponding to specified YYYYWW weeks
Syntax: 'obj' Świ 'Wk2Months'weeks |
| WkDaysDiff |
Description: Returns number of week days between YYYYMMDD dates specified in argument
Example: 'dd' Świ 'DaysDiff' (20000101 20000301)19991231 „… 1 61 |
| WkOfYr |
Description: Return week of year number for dates YYYYMMDD as YYYYWW
Example: 'dd' Świ 'WkOfYr'19991231 20000101 20000229 „… 199953 199953 200009 |
| Year |
Description: Return YYYY years in YYYYMMDD YYYYMM and/or YYYY dates |
| YearMonth |
Description: Return YYYYMM months in YYYYMMDD and/or YYYYMM dates |
TDates5 