Converting Strings

String to Number

Before trying to convert a string to a number it is a good idea to always make sure that the value is a numerical value.
The ISNUMERIC function will return True or False depending if the value can be evaluated as a number.
The CINT function converts a String to an Integer data type.

The CDBL function converts a String to a Double data type.
The CLNG function converts a String to a Long data type.
The CSNG function converts a String to a Single data type.

String to Date

The CDATE function converts a String to a Date data type.

Number to String

The CSTR function converts a Number to a String data type.

Date to String

The CSTR function converts a Date to a String data type.
The DATESERIAL function returns a date given a year, month and day.