Bookshelf Home | Contents | Index | PDF |
Siebel VB Language Reference > Methods Reference for Siebel VB > Date and Time Methods > Convert String to Date MethodThe Convert String to Date method converts a string to a date. It returns a date variable type that represents a date from January 1, 100, through December 31, 9999, where January 1, 1900, is 2. For more information, see Variants. Note the following:
For ways to display the desired result of a date conversion, see Set String Format Method. FormatThe following table describes the arguments that you can use with this method.
If the value that the date argument contains is not in a valid date format, then this method returns a Type Mismatch error. Using the DateValue Statement With the GetFormattedFieldValue StatementTo avoid a locale conflict, it is recommended that you do not use the DateValue statement together with the GetFormattedFieldValue statement. Note the following:
In this example, if a client connects to a DEU object manager on a Siebel Server where the Regional Options parameter is set to English (United States), then the GetFormattedFieldValue statement returns a string that contains a date that it formats for DEU, but the DateValue statement expects a string formatted for ENU. This situation results in the following error in Siebel VB: ExampleThe following example displays the date for one week from the date that the user enters: Sub Button_Click |
Siebel VB Language Reference | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |