Date formatting in VBScript

4.32 (31 votes)

A cheat sheet for people who want to format dates using VBScript

<%= 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: 214769

8 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 !!!!

- Eduardo

Thank you, very helpful.

- Paul

Hi This subject has been very helpful, but I require slight.y more.......
DatePart("yyyy", Now) & "-" & DatePart("m", Now) & "-" & DatePart("d", Now) gives the format 2016-3-4, however i want it to be 2016-03-04, how can I achieve this?

I tried mm and dd but this did not work

Recent Comments

Thomas 05/03/2018 00:59
In response to I'm Not Writing A Book On Razor Pages
There's a typo on this page: = true)] should be [BindProperty(SupportsGet = true)]...

Rolf Herbert 04/03/2018 19:25
In response to I'm Not Writing A Book On Razor Pages
So is MS deprecating razor Web Pages..? Is it dead..? I wish they would stop killing things so its...

Borut 17/02/2018 12:59
In response to I'm Not Writing A Book On Razor Pages
Mike, is it possible that Web Pages and Razor Pages "live" together in one web application? I a I...

hrboyce 09/02/2018 04:44
In response to I'm Not Writing A Book On Razor Pages
Mike, First thanks for doing this but I have to ask, any chance you would consider converting one of...

aziz sallam 07/02/2018 10:18
In response to I'm Not Writing A Book On Razor Pages
u are a great man...

Satyabrata Mohapatra 31/01/2018 11:36
In response to I'm Not Writing A Book On Razor Pages
This is a great news!!!! Thanks...

tangdf 30/01/2018 07:25
In response to I'm Not Writing A Book On Razor Pages
=> { o.ConfigureFilter(new IgnoreAntiforgeryTokenAttribute()); }); The extension method does...

Obinna Okafor 30/01/2018 04:02
In response to I'm Not Writing A Book On Razor Pages
Thank you very much. I would like to see a project built from scratch using Razor Pages. And it show...

rachida Dukes 31/10/2017 13:52
In response to Customising Identity in Razor Pages
Thanks again for this wonderful tutorial. I followed all the steps in this section called: Adding...

Rachida 31/10/2017 12:06
In response to Customising Identity in Razor Pages
Thanks very much for this wonderful tutorial, it helped a lot....