Namespace: VBA
Class VBDateParser
A parser for arbitrary date/time strings.
| Fields | |
|---|---|
| YEAR_BEFORE_MONTH - bit indicating that the year comes before the month. | bit indicating that the year comes before the month. |
| YEAR_BEFORE_DAY - bit indicating that the year comes before the day. | bit indicating that the year comes before the day. |
| MONTH_BEFORE_DAY - bit indicating that the month comes before the day. | bit indicating that the month comes before the day. |
| YEAR_AFTER_MONTH - bit indicating that the year comes after the month. | bit indicating that the year comes after the month. |
| YEAR_AFTER_DAY - bit indicating that the year comes after the day. | bit indicating that the year comes after the day. |
| MONTH_AFTER_DAY - bit indicating that the month comes after the day. | bit indicating that the month comes after the day. |
| DD_MM_YY - day/month/year order. | day/month/year order. |
| MM_DD_YY - month/day/year order. | month/day/year order. |
| MM_YY_DD - month/year/day order. | month/year/day order. |
| DD_YY_MM - day/year/month order. | day/year/month order. |
| YY_DD_MM - year/day/month order. | year/day/month order. |
| YY_MM_DD - year/month/day order. | year/month/day order. |
| Methods |
|---|
|
Function getOrderString(order As Integer) As String
Return a string representation of the order value.
|
|
Function monthNameToNumber(str As String) As Integer
Convert the supplied month name to its numeric representation.
For example, "January" (or any substring) would return 1 and "December" would return 12. |
|
Function parse(dateStr As String) As GregorianCalendar
Extract a date from a string, defaulting to YY-MM-DD
order for all-numeric strings.
|
|
Function parse(dateStr As String, order As Integer) As GregorianCalendar
Extract a date from a string.
|
|
Function parse(dateStr As String, order As Integer, ignoreChanges As Boolean) As GregorianCalendar
Extract a date from a string.
|
|
Function prettyString(cal As GregorianCalendar) As String
Return a printable representation of the date.
|
|
Function toString(cal As GregorianCalendar) As String
Return a basic representation of the string.
|
|
Function toSQLString(cal As GregorianCalendar) As String
Return a string representation of the date suitable for use in
an SQL statement.
|