Visual Basic® Scripting Edition
|| Language Reference |
Returns an expression formatted as a date or time.
The FormatDateTime function syntax has these parts:
Part Description Date Required. Date expression to be formatted. NamedFormat Optional. Numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used.
The NamedFormat argument has the following settings:
Constant Value Description vbGeneralDate 0 Display a date and/or time. If there is a date part, display it as a short date. If there is a time part, display it as a long time. If present, both parts are displayed. vbLongDate 1 Display a date using the long date format specified in your computer's regional settings. vbShortDate 2 Display a date using the short date format specified in your computer's regional settings. vbLongTime 3 Display a time using the time format specified in your computer's regional settings. vbShortTime 4 Display a time using the 24-hour format (hh:mm).
Note: Since all the Named Formats related to the date are relative to regional settings, the only way to consistantly get a date in a standard format is to build it with the month, day and year functions. For example, inserting a date and time into an SQL expression would need something like: month(datetime)&"/"&day(datetime)&"/"&year(datetime) & " " & FormatDateTime(datetime,4)
|file: /Techref/language/asp/vbs/vbscript/81.htm, 4KB, , updated: 2007/2/20 18:04, local time: 2018/9/21 09:42,
|©2018 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE. Questions?|
<A HREF="http://www.piclist.com/techref/language/asp/vbs/vbscript/81.htm"> Microsoft® Visual Basic® Scripting Edition </A>
|Did you find what you needed?|
PICList 2018 contributors:
o List host: MIT, Site host massmind.org, Top posters @20180921 RussellMc, Van Horn, David, Sean Breheny, David C Brown, Isaac M. Bavaresco, Bob Blick, Neil, Denny Esterline, Harold Hallikainen, John Gardner,
* Page Editors: James Newton, David Cary, and YOU!
* Roman Black of Black Robotics donates from sales of Linistep stepper controller kits.
* Ashley Roll of Digital Nemesis donates from sales of RCL-1 RS232 to TTL converters.
* Monthly Subscribers: Gregg Rew. on-going support is MOST appreciated!
* Contributors: Richard Seriani, Sr.
Welcome to www.piclist.com!