|
VBScript FormatDateTime Function
 Complete VBScript Reference
The FormatDateTime function formats and returns a valid date or time expression.
Syntax
|
FormatDateTime(date,format)
|
| Parameter |
Description |
| date |
Required. Any valid date expression (like Date()
or Now()) |
| format |
Optional. A Format value that specifies the date/time format to use |
Example 1
document.write("The current date is: ")
document.write(FormatDateTime(Date()))
Output:
The current date is: 2/22/2001
|
Example 2
document.write("The current date is: ")
document.write(FormatDateTime(Date(),1))
Output:
The current date is: Thursday, February 22, 2001
|
Example 3
document.write("The current date is: ")
document.write(FormatDateTime(Date(),2))
Output:
The current date is: 2/22/2001
|
| Constant |
Value |
Description |
| vbGeneralDate |
0 |
Display a date in format mm/dd/yy. If the date parameter is Now(), it
will also return the time, after the date |
| vbLongDate |
1 |
Display a date using the long date format: weekday, month day, year |
| vbShortDate |
2 |
Display a date using the short date format: like the default (mm/dd/yy) |
| vbLongTime |
3 |
Display a time using the time format: hh:mm:ss PM/AM |
| vbShortTime |
4 |
Display a time using the 24-hour format: hh:mm |
Complete VBScript Reference
Need an easy way to get data into XML, or transform XML to another format?
MapForce lets you map XML data to/from any combination of XML, database, flat file, Excel 2007, XBRL, or Web services data.
Then it transforms data instantly or auto-generates royalty-free data integration code for recurrent conversions.
Download a free, fully functional 30-day trial to experience the following features:
- Easy-to-use, graphical data mapping interface
- Instant data transformation
- XSLT 1.0/2.0 and XQuery code generation
- Java, C#, and C++ code generation
- Advanced data processing functions
- Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more
- Visual Studio & Eclipse integration
Download a fully-functional trial today!
|
|
|
|
