Beyond today's needs
ASP Express Home | What You Get | Pricing Information
New-->Online User Count
Using DatePart and other Date Functions
(Updated) Using Variables, Single & DoubleQuotes with SQL Statements in ASP
(Updated) Emailing Form Results
Mass Emailing with CDO
Using The Ad Rotator
ASCII Character Set 0-127
There are different intervals you can use when you use DatePart (listed at bottom of page), along with several constants (which I won't get into on this page). DatePart returns part of a specified date in this form:
DatePart(interval, date[, firstdayofweek[, firstweekofyear]])
List of Arguments
Required. String expression that is the interval of time you want to return. See Settings section for values.
Required. Date expression you want to evaluate.
Optional. Constant that specifies the day of the week. If not specified, Sunday is assumed. See Settings section for values.
Optional. Constant that specifies the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs. See Settings section at the bottom of the page for useable values.
Below are examples of some different ways to use DatePart, along with other popular date-type functions. Below each example is the code which creates it.
Here is today's date (using Date) : 8/20/2019
The month's name is August
Response.Write("<B>The month's name is </B> " & MonthName(currentmonth))
Number of the month : 8
<% response.Write "<B>Number of the month </B> : " & Currentmonth %>;
Here is the abbreviated month :
Response.Write monthname(currentmonth, true)
The year is : 2019
response.Write "<B>The year is </B> : " & MyYear
Today's date is :20
response.Write "Today's date is :" & MyWeekday
Here is the Day of the week :
Here is the Week of the Year :
The day of the year is : 232
(Which means that here are 133 Days Left this year)
response.Write "<B>The day of the year is </B> : " & MyYear
response.Write "<br>(<I>Which means that here are " & left & " Days Left this year</I>)"
Intervals and Constants for DatePart
||Day of year
||Week of year
The firstdayofweek argument can have any the following values:
||Use National Language Support (NLS) API setting.