Convert Number to Date Method

The Convert Number to Date method converts an expression to the data type variant of type date. Note the following:

• It returns a date variable type that represents a date from January 1, 100, through December 31, 9999. A value of 2 represents January 1, 1900.

• It represents a time as fractional days.

• It accepts string and numeric values.

• It converts the time portion of a date expression in the following situations:

• If you include a time portion as part of the expression.

• If the time expression is the only argument.

To compare dates, you must make sure that you format these dates consistently with each other. You can use this method to convert both expressions before Siebel VB compares them.

For ways to display the desired result of a date conversion, see Set String Format Method.

For more information, see Variants.

Format

CVDate(expression)

The following table describes the arguments that you can use with this method.

Argument	Description
expression	Any expression that Siebel VB can evaluate to a number.

How the Operating System Affects the Date Format

The date format depends on the format that the operating system uses. For example, if the operating system uses the mm/dd/yyyy format, then the input argument must use the mm/dd/yyyy format or the mm-dd-yyyy format. If you use an integer value, then to calculate this date Siebel eScript adds this integer as the number of days after the year 1900. In this situation, it returns a date in the mm/dd/yyyy form.

Example

The following example displays the date for one week from a date that the user enters:

Sub Button_Click
      Dim str1 as String
   Dim nextweek
   Dim msgtext as String
i: 
   str1 = "2/5/2001"
   answer = IsDate(str1)
   If answer = -1 then
      str1 = CVDate(str1)
      nextweek = DateValue(str1) + 7
      msgtext = "One week from the date entered is:
      msgtext = msgtext & "Format(nextweek,"dddddd")
   Else
      Goto i
   End If
End Sub