IsNumeric Function
IsDate Function
Year Function
Date Function
Time Function
IsNumeric Function: Evaluates whether an expression can be converted to Date or Not.
Example:
Dim MyVar, MyCheck
MyVar = 53 ' Assigns a Numeric value.
MyCheck = IsNumeric(MyVar) ' Returns True.
MsgBox MyCheck
MyVar = "459.95" ' Assigns a String which consists of Number
MyCheck = IsNumeric(MyVar) ' Returns True.
MsgBox MyCheck
MyVar = "45 Help" ' Assigns a String.
MyCheck = IsNumeric(MyVar) ' Returns False.
MsgBox MyCheck
IsDate Function: Evaluates whether an expression is a number or not.
Example:
Dim MyDate, YourDate, NoDate
MyDate = "October 19, 1962": YourDate = #10/19/62#: NoDate = "Hello"
Msgbox "Value of MyDate is "&IsDate(MyDate)
Msgbox "Value of Your Date is "&IsDate(YourDate)
Msgbox "Value of NoDate variable is "&IsDate(NoDate)
Year Function: Returns the whole number representing an Year
Dim MyDate, MyYear
MyDate = #October 19, 1962# ' Assign a date.
MyYear = Year(MyDate) ' MyYear contains 1962.
Date Function: Returns the current system date.
MyDate = Date
Msgbox "Today's Date is "&MyDate
Time Function: Returns the current system time.
MyTime = Time
Msgbox "Current Time is "&MyTime
Table of Contents
- Scripting Techniques
- Data Types
- Variables
- Constants
- Conditional Statements
- Build-In-Functions
- Loop Statements
- Sample Scripts
- Comments
- Input Box
- VBScript-Excel Object
- VBScript - MS Word Object
- VBScript Dictionary Object
- VBScript - FSO - Drives
- VBScript - XML Object
- VBScript - FSO - Folders
- VBScript - FSO - Files
- VBScript - Coding Standards
Thursday, October 14, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment