Syntax: DateValue(StringDate as String) as Date

The DateValue function assignes a specific data to a type Date variable.  Converting a string representation of a date into a Date value.

Parameters: The StringDate can be different date formats in string, the following are a few examples:

• "January 10 2007"
• "January 10" - defaults to current system year
• "Jan 10 2007"
• "10/Jan/2007"
• "10/01/2007"
• "10/Jan/2007 14:10:10" - won't return the time portion

Returns the system date and time as a type Date.

Returns the system date (no time information).

Returns the current system time (no date information).

Use the TimeValue function to create time values for type Date variables.

Syntax: Day(DateValue as Date) as integer

Day(date) Returns a value 1–31 representing the day of the month

Parameter: The DateValue must be a valid date.

Hour(date) Returns a value 0–23 representing the hour of the day

Minute(date) Returns a value 0–59 representing the minute of the hour

Month(date) Returns a value 1–12 representing the month of the year