devxlogo

Helpful VBScript Date Functions

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, szYeardtTemp = DateszMonth = 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 szDateszDate = "March 14, 1999"Response.Write "The date is " & DateValue(szDate )

devx-admin

Share the Post: