Conversion, Date/Time

**Table:** 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.

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

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

Returns a date value containing the current date according to your system.