ParseDate
Syntax: Date.ParseDate(DateRep as String) as integer
This function will attempt to parse a date representation in a string DateRep. When successful the date object will be populated with that date. A value of 1 is returned if the string was recognized to be a date, else 0 will be returned. Valid representations are 12/25/02, 12.25.02, 25 Dec 02, 25 Dec. 02, 25 Dec 2002, 25 Dec. 2002, 25.Dec.02, 25.Dec.2002. The current century is assumed when only two digits are used for the year.
CookieTime
Syntax: Date.CookieTime( ) as string
Returns a string that represents the time formated as a GMT Cookie time (DAY, DD-MMM-YYYY HH:MM:SS GMT).
FormatDate
Syntax: Date.FormatDate(theformat as String) as string
Returns a string that represents the time formated with theformat. Format is made off of the following values:
Format character
a Lowercase Ante meridiem and Post meridiem. am or pm
A Uppercase Ante meridiem and Post meridiem. AM or PM
B Swatch Internet time. 000 through 999
d Day of the month, 2 digits with leading zeros. 01 to 31
D A textual representation of a day, three letters. Mon through Sun
F A full textual representation of a month, such as January or March. January through December
g 12-hour format of an hour without leading zeros. 1 through 12
G 24-hour format of an hour without leading zeros. 0 through 23
h 12-hour format of an hour with leading zeros. 01 through 12
H 24-hour format of an hour with leading zeros. 00 through 23
i Minutes with leading zeros. 00 to 59
j Day of the month without leading zeros. 1 to 31
l (lowercase 'L') A full textual representation of the day of the week. Sunday through Saturday
L Whether it's a leap year. 1 if it is a leap year, 0 otherwise.
m Numeric representation of a month, with leading zeros. 01 through 12
M A short textual representation of a month, three letters. Jan through Dec
n Numeric representation of a month, without leading zeros. 1 through 12
s Seconds, with leading zeros. 00 through 59
S English ordinal suffix for the day of the month, 2 characters. st, nd, rd or th. Works well with j
t Number of days in the given month. 28 through 31
U Seconds since the Unix Epoch (January 1 1970 00:00:00 GMT). See also time()
w Numeric representation of the day of the week. 0 (for Sunday) through 6 (for Saturday)
W ISO-8601 week number of year, weeks starting on Monday. Example: 24 (the 24th week in the year)
Y A full numeric representation of a year, 4 digits. Examples: 1999 or 2003
y A two digit representation of a year. Examples: 99 or 03
z The day of the year (starting from 0). 0 through 365.
Hour / Minutes / Seconds
Data Type: Integer
These properties return their respective values. These properties are readonly
Day / Month / Year
Data Type: Integer
These properties return their respective values. Year is always 4 digits. Month is the number of the month. These properties are readonly
WeekofYear
Data Type: Integer
The number of the week the current day falls. From the total of weeks in a year. This property is readonly.
DayofWeek
Data Type: Integer
The day of the week. 1 is Sunday, 7 is Saturday. This property is readonly.
DayofYear
Data Type: Integer
The number of days since 1 January of the current year. This property is readonly.
TotalSeconds
Data Type: Integer
The total of seconds since January 1, 1904. This property is the base for all of the other properties. When you modify this property all of the others will change to reflect the value represented by the TotalSeconds.
ShortDate
Data Type: String
The string representation of the date in the format 12/25/02. This property is readonly.
LongDate
Data Type: String
The string representation of the date in the format Monday, December 31, 1997. This property is readonly.
ShortTime
DataType: String
The string representation of the time in the format 2:35 PM. This property is readonly.