Can I make VBScript format dates for me?
Well, VBScript's FormatDateTime leaves a lot to be desired. There really are only two ways to format a date by itself: VBLongDate and VBShortDate. Below are a few functions that will help you get dates into other relatively common formats. Many of these functions use the following function, from Article #2300:
(This is the preferred date format for passing dates to a SQL Server database, as it eliminates the need to worry about regional settings. See Article #2260 for more information.)
(This is the only safe date format to pass to Access.)
DD Mon YY
Weekday, Month D
Please let us know if there are any other date formats you'd like to see.
Replicating VB's Format() function
Thanks to Chris Hohmann, who pointed out a script by Scott Dixon which provided the basis for the following:
The fmt object depends on the availability of MSSTDFMT.dll, which is installed by Visual Studio 6.0. I have not tried to run this script on a machine that did not have Visual Studio 6.0 or later installed, so I'm not sure it will work if you simply copy and/or register the DLL on the target machine.
You can also see this date formatting class for other ideas.
Related ArticlesCan I get millisecond accuracy in ASP?
Could I get a little help with dates?
Given a date, how do I find the beginning and end of that week?
Given two dates, how do I determine an age?
How do I calculate dates, such as the first day of the month?
How do I convert a DATEDIFF to days, hours, and minutes?
How do I convert a timespan, in seconds, to HH:MM:SS?
How do I convert local time to UTC (GMT) time?
How do I count the number of business days between two dates?
How do I delimit/format dates for database entry?
How do I determine the number of seconds since 1/1/1970?
How do I display time in military format?
How do I implement a calendar / datepicker in ASP?
How do I select time only from a DATETIME column?
Why do I have problems inserting NOW() into a database?