Conversion, Date/Time

Conversion, Date/Time

Name	Syntax	Description
Cstr	Cstr(...)	Convert to string
Val	Val("198th Street")	Returns the numbers contained in a string as a numeric value of appropriate type. If the string does not contain any numbers, 0 is returned.
CDbl	CDbl(...)	Convert to Double
CInt	CInt(...)	Convert to Integer
Cdate	CDate("October 19, 1962")	Convert to date.
Str	Str(NUMBER)	Returns a string representation of a number.
Day	Day(DATETIME)	Returns an integer value from 1 to 31 representing the day of the month.
Hour	Hour(DATETIME)	Returns an integer value from 0 to 23 representing the hour of the day.
Month	Month(DATETIME)	Returns an integer value from 1 to 12 representing the month of the year.
MonthName	MonthName(MONTH)	Returns a string value containing the name of the specified month. MONTH is the numeric designation of the month. For example, January is 1, February is 2, and so on.
Now	Now	Returns a date value containing the current date and time according to your system.
Year	Year(DATETIME)	Returns an integer value from 1 to 9999 representing the year part of a specified date.
Today	Today	Returns a date value containing the current date according to your system.