Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic, Web
Expertise: Intermediate
Mar 15, 1999

Helpful VBScript Date Functions

VBScript has some neat date functions. For example, if you want to display a database date field such as "3/14/99" as "Sunday, March 14, 1999", try this code:
 
Dim dtTemp, szMonth, szDayName, szDay, szYear

dtTemp = Date
szMonth = MonthName(Month(dtTemp))
szDay = Day(dtTemp)
szYear = Year(dtTemp)
szDayName = WeekdayName(Weekday(dtTemp), False, 0)

Response.Write "Today is " & szDayName & ", " & szMonth & " " & szDay & ", " & szYear
Conversely, if you want to convert March 14, 1999 to 3/14/1999, use this code:
 
Dim szDate
szDate = "March 14, 1999"
Response.Write "The date is " & DateValue(szDate )
William Wen
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date