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