Date formatting in VBScript

Cheat sheet

<%= Date()%> 08/04/2007
<%=Now()%> 08/04/2007 20:20:15
<%=Time()%> 20:20:15
<%=FormatDateTime(Now(),vbGeneralDate)%> 08/04/2007 20:20:15
<%=FormatDateTime(Now(),vbLongDate)%> 08 April 2007
<%=FormatDateTime(Now(),vbShortDate)%> 08/04/2007
<%=FormatDateTime(Now(),vbLongTime)%> 20:20:15
<%=FormatDateTime(Now(),vbShortTime)%> 20:20
<%=Year(Now())%> 2007
<%=Month(Now())%> 4
<%=Day(Now())%> 8
<%=Hour(Now())%> 20
<%=Minute(Now())%> 20
<%=Second(Now())%> 15
<%=WeekDay(Now())%> 1
<%=WeekDayName(WeekDay(Now()))%> Sunday
<%=WeekDayName(WeekDay(Now()),1)%> Sun
<%=MonthName(Month(Now()))%> April
<%=MonthName(Month(Now()),1)%> Apr
   
DatePart("d", Now) 8 (Day of Month)
DatePart("w", Now) 1 (Day Of Week)
DatePart("m", Now) 4 (Month of Year)
DatePart("ww", Now) 15 (Week of Year)
DatePart("y", Now) 98 (Day of Year)
DatePart("yyyy", Now) 2007 (Year)
DatePart("q", Now) 2 (Quarter)
DatePart("h", Now) 20 (Hour)
DatePart("n", Now) 20 (Minute)
DatePart("s", Now) 15 (Second)

 

vbUseSystem

0

Uses the National Language Support API to determine the first full week based on the regional and language settings.

vbFirstJan1

1

Sets the first week as the week in which January 1 occurs. (Default)

vbFirstFourDays

2

Sets the first week as the first week to have at least four days in it.

VbFirstFullWeek

3

Sets the first week as the first week that begins on a Sunday.

 

DatePart("ww", Now, vbUseSystem) 14
DatePart("ww", Now, vbFirstJan1) 15
DatePart("ww", Now, vbFirstFourDays) 14
DatePart("ww", Now, VbFirstFullWeek) 15

Use of concatentation to customise date display:

<%
Response.Write WeekDayName(WeekDay(Now())) & _
", " & MonthName(Month(Now())) & _
" " & Day(Now()) & ", " & Year(Now()) 
%>

gives

Sunday, April 8, 2007

To write out the ordinal suffix for the day:

<%
Select Case Day(Now())
Case 1,21,31
ordsuffix = "st"
Case 2,22
ordsuffix = "nd"
Case 3,23
ordsuffix = "rd"
Case else
ordsuffix = "th"
End select
Response.Write (WeekDayName(WeekDay(Now())))
Response.Write (", ")
Response.Write (MonthName(Month(Now())))
Response.Write (" ")
Response.Write (Day(Now())
Response.Write (ordsuffix)
Response.Write (" ")
Response.Write (Year(Now())
%>

Sunday, April 8th 2007

Date Posted:
Last Updated:
Posted by:
Total Views to date: 141813

6 Comments

- sagnik

nice ..............thanks !

- Chuck

Very nice, indeed..I was almost there; this fixed my brain block!

- Dan Walter

DatePart("w", Now) returns the day of the week 1-7, not the week of the month.

- Mike

Thanks for spotting that, Dan.

- ucrajee

Nice info. My requirement was to have yyyy-mm-dd. But vbs was giving mm/dd/yyyy. This article helped me in changing the script to: DatePart("yyyy", Now) & "-" & DatePart("m", Now) & "-" & DatePart("d", Now)

- Fairoze Mohamed Musthafa

Appreciated !!!!

Recent Comments

Gayan 7/3/2015 6:20 AM
In response to 7 C# 6.0 Features That Every ASP.NET Developer Should Know About
Great Article thanks...

Semil 7/1/2015 7:03 AM
In response to iTextSharp - Drawing shapes and Graphics
I have created a rectangle using above methode. Now I want to add a text in the center of this How I...

Satyabrata Mohapatra 6/30/2015 6:12 PM
In response to Reading Excel Files Without Saving To Disk In ASP.NET
Ahh.....this is awesome. Happy to see after a long time you wrote a article on web form :D...

Marty 6/30/2015 7:16 AM
In response to Posting Data With jQuery AJAX In ASP.NET Razor Web Pages
Mike, you're the Man! Another great article. So incredibly helpful. I'm definitely going to buy your...

Rohan 6/30/2015 5:32 AM
In response to ASP.NET MVC 5 with EF 6 - Working With Files
Very good and helpful tutorial. Thanks. Just wanted to know what would be the max file size limit we...

Fernando 6/30/2015 1:59 AM
In response to Programmatically accessing data from DataSource controls
What if I want to pass parameters natively using the DataSourceSelectArguments object, instead of be...

pankaj 6/29/2015 3:13 PM
In response to How to retain carriage returns or line breaks in an ASP.NET web page
very nice i'm use this in my code thank you.... ...

Mike 6/29/2015 2:22 AM
In response to MVC 5 with EF 6 in Visual Basic - Sorting, Filtering and Paging
This is the first example that I have found that works....

Marty 6/28/2015 4:57 AM
In response to Posting Data With jQuery AJAX In ASP.NET Razor Web Pages
Mike, what if I don't want to render back the text to the browser, but I want to send it some other...

Mike 6/27/2015 4:00 PM
In response to Migrating Classic ASP To ASP.NET Razor Web Pages Part One- Razor Syntax And Visual Basic
have you used any of the code converters to convert classic asp to c#? If so, which one do you have...