Question: How can I easily display a nicely formatted date variable? [ Print this FAQ]
Answer: Use the
FormatDateTime takes two input paraemeters, a required date variable and an optional date format. There are five different date formats available:
vbGeneralDate - displays a date as a short date and a time as a long time.
vbLongDate - displays a date in the long format
vbShortDate - displays a date in the short format
vbLongTime - displays a time using the long format
vbShortTime - displays a time using the 24-hour format
The long and short formats are specified by the regional settings on the Web server. An example of using the
FormatDateTime function can be seen below:
dtNow = Now() Response.Write FormatDateTime(dtNow, vbGeneralDate) & "<BR>" Response.Write FormatDateTime(dtNow, vbLongDate) & "<BR>" Response.Write FormatDateTime(dtNow, vbShortDate) & "<BR>" Response.Write FormatDateTime(dtNow, vbLongTime) & "<BR>" Response.Write FormatDateTime(dtNow, vbShortTime) & "<BR>"
The output of the above script is:
9/24/00 3:23:48 PM
Sunday, September 24, 2000 9/24/00 3:23:48 PM 15:23 For more information be sure to read the technical docs! Also be sure to check out this FAQ: How can I display dates in a completely custom format (that might not be supported by
FAQ posted by Scott Mitchell at
9/24/2000 3:44:53 PM to the
Dates and Times category.
This FAQ has been viewed 75,619 times.
Do you have a FAQ you'd like to suggest?
Suggestions? Comments? If so,
send it in!
Also, if you'd like to be a FAQ Admin (creating/editing FAQs),
let me know! If you are looking for other FAQs, be
sure to check out the 4Guys
FAQ and Commonly Asked Messageboard Questions!
Most Viewed FAQs: 1.) How can I format numbers and date/times using ASP.NET? For example, I want to format a number as a currency. ( 761643 views)
2.) I am using Access and getting a 80004005 error (or a (
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)' error) when trying to open a connection! How can I fix this problem?
3.) How can I convert a Recordset into an array? Also, how can I convert an array into a Recordset? ( 202549 views)
4.) How can I quickly sort a VBScript array? ( 196039 views)
5.) How can I find out if a record already exists in a database? If it doesn't, I want to add it. ( 156019 views)
6.) How do I display data on a web page using arrays instead of Do...While...MoveNext...???... ( 152331 views)
7.) When I get a list of all files in a directory via the (
FileSystemObject, they aren't ordered in any reasonable way.
How can I sort the files by name? Or by size? Or by date created? Or...
8.) For session variables to work, must the Web visitor have cookies enabled? ( 110162 views)
9.) Can I send emails ( without using CDONTS? 107083 views)
10.) How can I take the result of a ( SELECT...MULTIPLE or a group of same-named checkboxes and turn it into a query? That is, if the user selects 3 answers, how can I construct a query that looks for all 3? 106308 views)
Last computed at 9/17/2007 3:22:00 AM