LitDev Extension API
LDDateTime
Time and Date conversion.
The date format is "25/01/2012 22:18:52", the time part is optional.
The date part will be dependent on your locale, e.g. in US it will be "01/25/2012 22:18:52".
An OADate is the number of days (and part days) since 30 December 1899, allowing dates to be added or subtracted.
Add | FromOADate | GetDay |
GetDayName | GetHour | GetMinute |
GetMonth | GetMonthName | GetSecond |
GetYear | Now | NowOADate |
OADate | Subtract | ToOADate |
Add(date,offset)
Calculate a date from input date and an offset in days.
date The input date.
offset An offset in days.
returns A date equivalent to the input date + offset.
The format is "25/01/2012 22:18:52", the time part is optional.
The date part will be dependent on your locale, e.g. in US it will be "01/25/2012 22:18:52".
FromOADate(OAdate)
Convert OADate to date string.
OAdate The OADate to convert.
The number of days since 30 December 1899 (OADate).
returns The date string.
The format is "25/01/2012 22:18:52", the time part is optional.
The date part will be dependent on your locale, e.g. in US it will be "01/25/2012 22:18:52".
GetDay(OAdate)
Get day of the month from OADate.
OAdate The OADate.
The number of days since 30 December 1899 (OADate).
returns The month.
GetDayName(OAdate)
Get day of the week from OADate.
OAdate The OADate.
The number of days since 30 December 1899 (OADate).
returns The day name.
GetHour(OAdate)
Get hour from OADate.
OAdate The OADate.
The number of days since 30 December 1899 (OADate).
returns The hour.
GetMinute(OAdate)
Get minute from OADate.
OAdate The OADate.
The number of days since 30 December 1899 (OADate).
returns The minute.
GetMonth(OAdate)
Get month from OADate.
OAdate The OADate.
The number of days since 30 December 1899 (OADate).
returns The month.
GetMonthName(OAdate)
Get month name from OADate.
OAdate The OADate.
The number of days since 30 December 1899 (OADate).
returns The month name.
GetSecond(OAdate)
Get second from OADate.
OAdate The OADate.
The number of days since 30 December 1899 (OADate).
returns The second.
GetYear(OAdate)
Get year from OADate.
OAdate The OADate.
The number of days since 30 December 1899 (OADate).
returns The year.
Now()
The current date and time.
returns The current date and time.
The format is "25/01/2012 22:18:52", the time part is optional.
The date part will be dependent on your locale, e.g. in US it will be "01/25/2012 22:18:52".
NowOADate()
The current OADate.
returns The number of days (and part days) since 30 December 1899 (OADate).
OADate(year,month,day,hour,minute,second)
Create OADate from date and time values.
year The year.
month The month.
day The day.
hour The hour.
minute The minute.
second The second.
returns The number of days (and part days) since 30 December 1899 (OADate).
Subtract(date1,date2)
Calculate a number of days between two dates.
date1 The input date1.
date2 The input date2.
returns The number of days (and part days) between the dates (date1-date2).
ToOADate(date)
Convert date string to OADate.
date The date string to convert.
The format is "25/01/2012 22:18:52", the time part is optional.
The date part will be dependent on your locale, e.g. in US it will be "01/25/2012 22:18:52".
returns The number of days (and part days) since 30 December 1899 (OADate).