Additional Info

Recent Comments

Alvin 5/12/2015 1:20 PM
In response to Razor Web Pages E-Commerce - Adding A Shopping Cart To The Bakery Template Site
Maybe ability to update quantity of the items once you are in the "Review Cart" step. Also, if on...

Rakesh Panchal 5/12/2015 5:02 AM
In response to ASP.NET MVC 5 with EF 6 - Working With Files
this is v v good web site for help...

Mariusz 5/11/2015 7:19 PM
In response to Introducing TagHelpers in ASP.NET MVC 6
In your comparison of old Html.RouteLink and new AnchorTagHelper where we can specify "title" and in...

Andrea 5/11/2015 3:40 PM
In response to Save And Retrieve Files From a Sql Server CE Database with WebMatrix
Please excuse my noob question. I am using your tips to add file upload to a form I have created. a...

Luis 5/10/2015 5:26 PM
In response to Accessing Your Model's Data from a Controller
Ok. I got it! Return RedirectToAction("Create") on the controller :-) thanks...

Luis 5/10/2015 4:08 PM
In response to Accessing Your Model's Data from a Controller
Hi. Great tutorial. I'm starting to learn MVC. What can I do for when the Create Button is it...

Abdirahman 5/7/2015 7:50 PM
In response to ASP.NET MVC 5 with EF 6 - Working With Files
Thank you very much....

Mike W 5/7/2015 4:25 PM
In response to How To Send Email In ASP.NET MVC
Does the EmailFormModel.cs model class map to db tables (ie: is add-migration needed) or is it a for...

Sedat Ozturk 5/7/2015 8:21 AM
In response to Getting the identity of the most recently added record
Thank you brother :))...

alex 5/6/2015 4:17 PM
In response to Working With Entity Framework Code First And JSON In ASP.NET Web Pages
hi how i start this project in visual studio...

Share

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: 138062

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 !!!!
Add your comment

If you have any comments to make about this article, please use this form to do so. Make sure that your comment relates specifically to the article above. More general comments can be posted through the form on the Contact page.

Please note, all comments are moderated, and I end up deleting quite a lot. The kind of things that will ensure your comment is deleted without ever seeing the light of day are as follows:

  • Requests to fix your code (post a question to forums.asp.net instead, please)
  • Gratuitous links to your own site or product
  • Anything abusive or libellous
  • Spam

I do not pass email addresses on to spammers, so a valid one will assist me in responding to you personally if required.