Bookshelf Home | Contents | Index | PDF |
Siebel VB Language Reference > Methods Reference for Siebel VB > Date and Time Methods > Convert Number to Date MethodThe Convert Number to Date method converts an expression to the data type variant of type date. Note the following:
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. FormatThe following table describes the arguments that you can use with this method. How the Operating System Affects the Date FormatThe 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. ExampleThe following example displays the date for one week from a date that the user enters: Sub Button_Click |
Siebel VB Language Reference | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |