In general, hard-coding dates and times as strings (as shown in this example) is not recommended.Use date literals and time literals, such as ACM-2/12/1969 ACM- and ACM- PM ACM-, instead.
Also, Fix and Int always return a value of the same type as is passed in.Use the Is Date function to determine if can be converted to a date or time.Any fractional part of the number is converted to a time of day, starting at midnight.CDate recognizes date formats according to the locale setting of your system.My Long2 = CLng(My Val2) ' My Long2 contains 25428.
Dim My Double1, My Double2, My Single1, My Single2 ' My Double1, My Double2 are Doubles.
For example, use CCur to force currency arithmetic in cases where single-precision, double-precision, or integer arithmetic normally would occur.
You should use the data-type conversion functions instead of Val to provide internationally aware conversions from one data type to another.
Implicit conversions of Long Long to smaller integrals are not allowed.
In general, you can document your code using the data-type conversion functions to show that the result of some operation should be expressed as a particular data type rather than the default data type.
Since there is now an intrinsic Date type, there is no further need for CVDate.